Does your code properly escape the backslash character as it writes to the database? IF you are NOT using 'cn=abc\\, def, ou=accounts' in your INSERT and UPDATE statements, you will get values that look like 'cn=abc, def, ou=accounts' in your data.
Without actual data, actual statements, a few lines of sample data, and the results of SHOW CREATE TABLE tablename\G, it's very hard to diagnose this problem further. Let's also move this discussion to the "General Discussion" ( mysql@lists.mysql.com) list as this problem does not seem to be related to any issue related to the server itself (yet). If it turns out to be a bug there is a separate list for those, too. Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Guofeng Zhang" <[EMAIL PROTECTED]> wrote on 12/22/2004 05:21:04 AM: > In our customer site, our application throws a duplicate key exception. > Based on the log printed by our application, we find that the values of > the primary key have the following pattern: > > cn=abc\, def, ou=accounts > > cn=abc\, ghi,ou=accounts > > Is the problem caused by these values > > > > We cannot know what cause the problem from our code, so we think that > maybe the MySQL internal implementation has some constraints. > > > > We can not go to the customer site to do further test. Any help are > appreciated very much. > > > > Thank you > > > > Guofeng > > >