Friday, March 03, 2006

MySQL character inserts

Interestingly, if there VARCHAR column with a record containing ',' and the attempt is made to insert ', ', MySQL reports that this is a duplicate key, thereby trimming the insertion. Tested and reproduced on 4.1.3-beta-standard.

No comments: