Trim Varchar Columns Trailing Spaces

[Auguy]

New to MySql, is there a setting to force all varchar columns to trim trailing spaces? It looks like it used to be automatic in older versions, but I can't find anywhere to set this as a default.

Auguy
Sylvania/Toledo Ohio

 

[ChrisHirst]

UPDATE table SET column = TRIM(column);

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

 

[Auguy]

Thanks, but do you know how to do it in a .Net dataadapter commmand like this

command.Parameters.Add("@FirstName", MySqlDbType.VarChar, 15, "FirstName")

I've tried adding Trim in various ways to this code, by can't seem to make it work.

Auguy
Sylvania/Toledo Ohio

 

[ChrisHirst]

Dunno, this is the MySQL forum so we give MySQL answers.

Try one of the .NET language forums.

http://www.tek-tips.com/threadforum.cfm?lev3=32

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum