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: [email protected] [mailto:[email protected]]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 <[email protected]>:
> 
> > 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:[email protected]]
> > Sent: Monday, September 18, 2006 2:34 PM
> > To: 'Marek Burakowski'; [email protected]
> > 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
> > [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]
> > 
> > 
> 
> 
> ****************************************************************************
> Marek Burakowski
> email: [email protected]
> 


****************************************************************************
Marek Burakowski
email: [email protected]

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