Hi. See:
http://dev.mysql.com/doc/mysql/en/Charset-config-file.html "Brown, Brooks" <[EMAIL PROTECTED]> wrote: > All of the unicode collations listed in the reference manual except the = > binary collations are not sensitive to diacritical marks. That is, if I = > do the following: > > create table t ( filename varchar(260) ) type=3DInnoDB CHARACTER SET = > utf8 collate utf8_unicode_ci; > > -- insert an e-acute > insert into t values ( x'c3a9' );=20 > > mysql> select * from t where filename =3D 'e'; > +------+ > | f | > +------+ > | =E9 | > +------+ > > The problem is that e really isn't the same as e-acute for the file = > system. Ideally, what I want is a collation that is case insensitive, = > but is sensitive to diacritical symbols, but a case sensitive collation = > would be okay if it were sensitive to diacritical symbols? Is there = > none available for utf8 as the manual indicates? If not, how difficult = > would it be to develop one? > > I am using 4.1.3 on Mac OS X. > > Brooks R. Brown > Software Engineer > Extensis, Inc. > <http://www.extensis.com/> > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
