I ran mysqld with arguments --default-character-set=utf8 and --default-collation=utf8_unicode_ci, and created a table with no collation specification. I didn't test specifically with ç, but e and e-acute were equivalent. For me this is was problem, but it sounds like for you it's the desired behavior.
-----Original Message----- From: Andrew Nagy [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 01, 2004 11:03 AM To: Brown, Brooks Cc: [EMAIL PROTECTED] Subject: Re: Utf8 collations Brooks, this isn't an answer to your question, but a question to you regarding what you have done. I would like to do a query such as: SELECT title FROM books WHERE title LIKE '%Francais%'; And in return get: +----------+ | title | +----------+ | Français | +----------+ Does the "CHARACTER SET utf8 collate utf8_unicode_ci" allow for this? How would one set the collation of international characters with english characters for searching? Thanks Andrew Brown, Brooks 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=InnoDB CHARACTER SET utf8 > collate utf8_unicode_ci; > > -- insert an e-acute > insert into t values ( x'c3a9' ); > > mysql> select * from t where filename = 'e'; > +------+ > | f | > +------+ > | é | > +------+ > > 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/> > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]