On 21.11.2007 15:18 CE(S)T, Marten Lehmann wrote: >> If I recall that correctly, utf8_swedish_ci is the collation to use for >> european/western european languages. Those Swedish people think they can >> stand for whole Europe... ;) >> >> Not tested my reply, though. > > and doesn't work either.
Okay. This is the closest match I've found in the MySQL manual. http://dev.mysql.com/doc/refman/5.0/en/charset-unicode-sets.html So German is not supported with Unicode in MySQL 5.0, it seems. SQLite supports adding user collations through code, which enables you to use a custom function to sort strings, like .NET or PHP offer one. This way, I can for example use natural sorting in SQLite from .NET applications. Does MySQL also have support for this? -- Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]> Visit my web laboratory at http://beta.unclassified.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]