having a problem with trim

[eruna]

I need to get rid of white spaces at the end of a field.

When I use "SELECT trim(field) from db"
It is still outputting with a space at the end.

Is it possible its some other type of hidden character?
Is there a way to strip non alphanumeric characters.

Ideas..

Thanks
E

[PHPycho]

This may help you:
http://dev.mysql.com/doc/refman/5.0/...#function_trim

[PHPycho]

This may help you:
http://dev.mysql.com/doc/refman/5.0/...#function_trim

[r937]

When I use "SELECT trim(field) from db"
It is still outputting with a space at the end.

please find one example where there is still some white space, then run this:

SELECT HEX(field)
  FROM daTable
 WHERE ... -- pick the row with the bad field

you will see that it isn't a blank/space but probably some other white space character like a carriage return or line feed

[eruna]

please find one example where there is still some white space, then run this:

SELECT HEX(field)
  FROM daTable
 WHERE ... -- pick the row with the bad field

you will see that it isn't a blank/space but probably some other white space character like a carriage return or line feed

Thanks for the tip. It turned out to be a non breaking space.