-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]