Is there a way to force an invisible "space" character to be stored at the END of a string in a column (either VARCHAR or CHAR), so that when it is retrieved the space at the end is not cut off?
No. I suggest that you use one of the TEXT types instead, which are not subject to trailing space trimming.
theString + space
or even,
theString + space + space + space, etc.
Currently, I can only get the string back as theString
Right. That's the documented behavior.
-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]