Hi,
I'm getting a problem whereby the data that I'm querying from a mySQL based database has a trailing spaces/characters.
E.g.
Data stored
User Number 1 Number 2
---------------------------------
"Joel" , "5" , "-5"
Data retrieved
"Joel " , " 5 " , " -5 "
I've tried using trim, and it works for the numbers but it doesn't work for the string, as it's a unrecognized character hence it doesn't get trimmed as it's not a space.
Anybody knows what is going on here?
Thanks!
Bookmarks