Re: Unique index (constraint) - utf8
Posted by:
Rick James
Date: November 12, 2010 12:04AM
The default collation for utf8 is utf8_general_ci, which treats upper/lowercase as equal, and ignores accents. So, they are treated equal.
utf8_bin would treat them as different.
ALTER TABLE name_results
MODIFY COLUMN `name` varchar(50) COLLATE utf8_bin DEFAULT NULL;
If you want case folding but not accent-ignoring, you are out of luck.
Subject
Views
Written By
Posted
3826
November 10, 2010 11:35AM
1073
November 11, 2010 03:02AM
969
November 11, 2010 09:03AM
Re: Unique index (constraint) - utf8
2588
November 12, 2010 12:04AM
979
November 12, 2010 02:18PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.