Christian Wollmann wrote:
By the way: Perhaps you could tell me how I can determine/change the encoding
of the database?
SHOW CREATE DATABASE db_name;
ALTER DATABASE db_name
[[DEFAULT] CHARACTER SET charset_name]
[[DEFAULT] COLLATE collation_name];
http://dev.mysql.com/doc/mysql/en/c
You could try:
SELECT memberid, lastname
FROM tblmembers
ORDER BY lastname COLLATE latin1_german2_ci ASC
It worked in my database. But I dont know, if my database is utf8.
By the way: Perhaps you could tell me how I can determine/change the encoding
of the database?
Kind regards
Christian
Nico Grubert <[EMAIL PROTECTED]> wrote on 22/07/2005 09:06:25:
>
> Hi there,
>
> I have a MySQL 4.1 DB running including a database whose character set
> is set to utf8.
> In the database I have a table "tblmembers" with some records containing
> german umlauts.
> How do I sort results with germ
