List:MySQL on Win32« Previous MessageNext Message »
From:Jorge Bastos Date:October 12 2006 9:18pm
Subject:Fw: Problem using 'ä,ö,å' in MySQL
View as plain text  
seams to me a charset problem,
why don't you use utf8?


----- Original Message ----- 
From: "Marek Burakowski" <marek.burakowski@stripped>
To: <win32@stripped>
Sent: Thursday, October 12, 2006 7:24 PM
Subject: 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@stripped [mailto:burakows@stripped]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@stripped>:
>
> > 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@stripped]
> > Sent: Monday, September 18, 2006 2:34 PM
> > To: 'Marek Burakowski'; win32@stripped
> > 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@stripped
> > +1(480)308-0641 (Voice)
> > +1(602)996-0376 (Fax)
> >
> >
> > -----Original Message-----
> > From: burakows@stripped [mailto:burakows@stripped]
> On
> > Behalf Of Marek Burakowski
> > Sent: Monday, September 18, 2006 6:33 AM
> > To: win32@stripped
> > 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=1
> >
> >
> > -- 
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
> > http://lists.mysql.com/win32?unsub=1
> >
> >
>
>
> ****************************************************************************
> Marek Burakowski
> email: marek.burakowski@stripped
>


****************************************************************************
Marek Burakowski
email: marek.burakowski@stripped

-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/win32?unsub=1


Thread
Fw: Problem using 'ä,ö,å' in MySQLJorge Bastos12 Oct