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