-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Tuesday 02 September 2003 5:40 pm, Morten Gulbrandsen wrote: > mysql> create table mytbl( c1 char(10) character set latin1_de); > ERROR 1115: Unknown character set: 'latin1_de'
IIRC latin1_de is not a character set in Mysql 4.1.. The character set "latin1" contains all western european characters... So you'll be fine with those. You can specify a German-specific sort order by using the collation settings. There is a "latin1_german1_ci" collation. (Also a "latin1_german2_ci", which works like the German phonebook instead of the dictionary.) So, you'd want: CREATE TABLE foo ( blah ... ) CHARACTER SET latin1 COLLATE latin1_german1_ci; - - Simon -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/VMnpPBt+tvwCnbYRAtxfAJ95zJyXpIcN4e0FqWMPuNwT9AqwUQCggc+9 2IES4NWNC97itxEvrVGdmHQ= =ejfA -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]