Hi,
an international site has some content in several latin languages, for
example English and French. Sometimes 2 pages, one in English and one in
French, have the same name except for an accent (for example, in
English, Demonstration, in French, Démonstration). The site's database
schema enforces page names to be unique. Trying to convert the content
to support UCS, this causes a problem because the collation we tried
using, utf8_unicode_ci, consider an accented letter and its unaccented
representation as the same.
What collations for UCS exist that distinguish accented characters from
their unaccented equivalents? I saw utf8_bin, but that seems very
different from utf8_unicode_ci, which I would like to use if it wasn't
for this problem. I would like something as close to utf8_unicode_ci as
possible.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
