>>>>> "ruschein" == ruschein <ruschein@stripped> writes:
ruschein> Also sprach Michael Widenius:
>> >>>>> "ruschein" == ruschein <ruschein@stripped>
> writes:
>>
ruschein> Hi,
ruschein> I'm trying to insert keys that differ only in the accents on
ruschein> the letters into a VARCHAR column. MySQL complains about
ruschein> duplicate keys. I need to support ISO 8859-1 or maybe even
ruschein> multibyte characters at some point. What can I do to have
ruschein> MySQL honour differences in accented charcters?
>>
>> Can you provide an example of this?
ruschein> If I try to insert both "bibliotheque" and "bibliothÈque" into a
> UNIQUE
ruschein> VARCHAR column I get an error messages about duplicate keys.
The problem here is that the default character map sorts and compares
'e' and 'é' identically.
>> Anyway, you can always create the column as BINARY if you don't want
>> to get correct ISO-8859-1 sorting.
ruschein> I most definitely *want* ISO-8859-1 sorting.
In this case you have to define your own character map; You can find
information how to do this in the MySQL manual.
>> Regards,
>> Monty
ruschein> Thank you for your response! BTW, it seems you have met my good friend
ruschein> Carl Vilbrandt in Japan?!
I haven't been in Japan, but David has. It's probably he who Carl
met..
Regards,
Monty
