Unicode Collation utf8_general_ci

2004-01-12 Thread Desmond Liu
I have a table that stores strings in utf8, using the default collation utf8_genera_ci. During comparison using LIKE, MySQL 4.1.1 seems to be able to handle case insensitivity of latin characters correctly but not other characters such as Greek. For example, I have a varchar column (mycol) with

Building mysql apps with CodeWarrior on Mac OS X

2003-12-24 Thread Desmond Liu
I'm tring to use CodeWarrior 9 to build a Mach-O target application on Mac OS X that uses the embedded mysql server library (libmysqld.a). I'm using the library that comes from standard Mac OS X binary distribution (the .dmg package). I can add libmysqld.a to the CodeWarrior project but whenlin