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 [at] mappi.helsinki.fi [mailto:burakows [at] 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 <DLancaster [at] envstd.com>:
>
> > 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 [at] vrtinc.com]
> > Sent: Monday, September 18, 2006 2:34 PM
> > To: 'Marek Burakowski'; win32 [at] 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 [at] vrtinc.com
> > +1(480)308-0641 (Voice)
> > +1(602)996-0376 (Fax)
> >
> >
> > -----Original Message-----
> > From: burakows [at] mappi.helsinki.fi [mailto:burakows [at] mappi.helsinki.fi]
> On
> > Behalf Of Marek Burakowski
> > Sent: Monday, September 18, 2006 6:33 AM
> > To: win32 [at] 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 [at] vrtinc.com
> >
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
> > http://lists.mysql.com/win32?unsub=DLancaster [at] envstd.com
> >
> >
>
>
> ************************************************************ ****************
> Marek Burakowski
> email: marek.burakowski [at] helsinki.fi
>
************************************************************ ****************
Marek Burakowski
email: marek.burakowski [at] helsinki.fi
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32 [at] m.gmane.org
