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/win32?unsub=gcdmw-win32@m.gmane.org

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

Marek,

I'm no expert, but when I insert a record using an SQL statement, I =
don=92t
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
lawson@vrtinc.com
+1(480)308-0641 (Voice)
+1(602)996-0376 (Fax)
=20

-----Original Message-----
From: burakows@mappi.helsinki.fi [mailto:burakows@mappi.helsinki.fi] On
Behalf Of Marek Burakowski
Sent: Monday, September 18, 2006 6:33 AM
To: win32@lists.mysql.com
Subject: Problem using 'ä,ö,=E5' 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 =3D 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

--=20
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: =
http://lists.mysql.com/win32?unsub=3Dlawson@vrtinc.com


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

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

In case anyone had the same problem, it indeed seems to be a windows issue.
When I wrote a php sript with the same code, the scandics worked fine.
The only time it gave errors was when using the client's "source" command.




> 5.0.16-nt
>
> -----Original Message-----
> From: burakows@mappi.helsinki.fi [mailto:burakows@mappi.helsinki.fi]On
> Behalf Of Marek Burakowski
> Sent: Tuesday, September 19, 2006 4:23 AM
> To: Don Lancaster
> Subject: RE: Problem using 'ä,ö,å' in MySQL
>
>
>
> Could you tell me which version of MySQL are you using, and is it running
> on
> Win or Linux? I have 5.0.24-community-nt running on WinXP.
>
>
> Lainaus Don Lancaster :
>
> > I tried the exact script in the e-mail (cut-and-paste, didn't even
> retype
> > it...) and it worked perfectly for me.
> >
> > -----Original Message-----
> > From: Lawson Cronlund [mailto:lawson@vrtinc.com]
> > Sent: Monday, September 18, 2006 2:34 PM
> > To: 'Marek Burakowski'; win32@lists.mysql.com
> > Subject: 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
> > lawson@vrtinc.com
> > +1(480)308-0641 (Voice)
> > +1(602)996-0376 (Fax)
> >
> >
> > -----Original Message-----
> > From: burakows@mappi.helsinki.fi [mailto:burakows@mappi.helsinki.fi]
> On
> > Behalf Of Marek Burakowski
> > Sent: Monday, September 18, 2006 6:33 AM
> > To: win32@lists.mysql.com
> > 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/win32?unsub=lawson@vrtinc.com
> >
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
> > http://lists.mysql.com/win32?unsub=DLancaster@envstd.com
> >
> >
>
>
> ************************************************************ ****************
> Marek Burakowski
> email: marek.burakowski@helsinki.fi
>


************************************************************ ****************
Marek Burakowski
email: marek.burakowski@helsinki.fi

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org