ERROR 1115: Unknown character set: 'latin1_de'

2003-09-02 Thread 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

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

2003-09-02 Thread 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

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

2003-09-02 Thread 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: