Oropeza Querejeta, Alejandro wrote:
Hi,
I have one table that is presenting strange behaviour, we set the
varchar field for not allow nulls so, on 5% of the records the
application is inserting blanks but when we select the value and we set
the condition ="" it returns the same as " " and " ".
Even, we tried to set the field into the primary key to try to correct
this, but is the same.
We double check on the application and we have a lot of validation code
to avoid this problem. Does anyone have any clue about it?
Best Regards
Alejandro
trailing spaces are removed on VARCHAR,
http://dev.mysql.com/doc/mysql/en/CHAR.html
--
Philippe Poelvoorde
COS Trading Ltd.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
