Sunday, June 14, 2009

Random thoughts for the dba on various platforms.

sql server (and others) insert returns duplicate key and you are sure it's not duplicate. Check your collation set; case insensitive character sets make Foo, foo, fOo, or FoO all the same and an attempt to insert any of these values in a unique indexed column will give you the useless "duplicate key" error.

No comments:

Post a Comment