ERROR 1115: Unknown character set: 'latin1_de'

[Morten Gulbrandsen]

mysql create table mytbl(  c1 char(10)   character set latin1_de);
ERROR 1115: Unknown character set: 'latin1_de'
mysql create table mytbl(  c1 char(10)   character set utf8);
ERROR 1115: Unknown character set: 'utf8'
mysql create table mytbl(  c1 char(10)   character set  sjis);
ERROR 1115: Unknown character set: 'sjis'
mysql select version();
+---+
| version() |
+---+
| 4.1.0-alpha-max-debug |
+---+
1 row in set (0.01 sec)

mysql

Hi again,

is this solved in a next release, Please ?

I need to insert statements in german language,
öäüß   
is part of that. 

Yours Sincerely

Morten Gulbrandsen



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 1115: Unknown character set: 'latin1_de'

[Simon]

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

Re: ERROR 1115: Unknown character set: 'latin1_de'

[Hans van Harten]

Simon wrote:
 So, you'd want:
 CREATE TABLE foo ( blah ... ) CHARACTER SET latin1 COLLATE
 latin1_german1_ci; 
You can enforce a different character set by configuration, but how to 
setup for a non-swedish(!) collation ??

HansH

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]