RE: Problem using 'ä,ö,å' in MySQL

Marek,

I'm no expert, but when I insert a record using an SQL statement, I don’t
specify the auto increment field as that is filled in by the insertion
process in MySQL - at least in my case.  I don't know if that's related to
the problem you're having but it is different than the SQL I'm using.  I
also use a "bigint" type for the id column to insure that it won't wrap
around in the next couple of lifetimes.

Regards.



Lawson
[email protected]
+1(480)308-0641 (Voice)
+1(602)996-0376 (Fax)
 

-----Original Message-----
From: [email protected] [mailto:[email protected]] On
Behalf Of Marek Burakowski
Sent: Monday, September 18, 2006 6:33 AM
To: [email protected]
Subject: Problem using 'ä,ö,å' in MySQL



I can't seem to figure out how to get my database to accept scandinavian
characters. A source file example:

CREATE TABLE IF NOT EXISTS `scantest` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`scandicletter` VARCHAR( 30 ) NOT NULL
) ENGINE = innodb CHARACTER SET utf8;
INSERT INTO scantest (id, scandicletter) VALUES (NULL, 'Ääää');
INSERT INTO scantest (id, scandicletter) VALUES (NULL, 'Öööö');
INSERT INTO scantest (id, scandicletter) VALUES (NULL, 'Åååå');

when run in MySQL Client yields the following:
'Query OK, 0 rows affected' for create table and
'ERROR 1406 (22001): Data too long for column 'scandicletter' at row 1'

The same happens with all charsets, at least the more common ones I have
tried. Net search showed some people having the same problem but solutions
mostly stated that it is "Windows-related" and did not help for me.


 - Marek

-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]


-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]