ember 13, 2006 2:03 PM
To: mysql@lists.mysql.com
Subject: MySQL 5.0.27: character problem
Hello, I'm using MySQL version 5.0.27 under Windows XP
professional. I
have a text file with some SQL commands (I create a few tables and
insert some rows into them). I noticed that all columns where
I tried
Thanks for the help, Jerry, I think I solved it. I opened the script (a
standard windows text file) in UltraEdit. It can convert between some
different text formats. After some experimenting it seems that selecting
the conversion ansi-to-oem does the trick! It's now inserted properly
into mysql.
EMAIL PROTECTED] On Behalf Of Eric Lilja
> Sent: Thursday, December 14, 2006 4:36 PM
> To: mysql@lists.mysql.com
> Subject: Re: MySQL 5.0.27: character problem
>
> Here's what I get when I perform mysql> show variables like "char%";
> +-
riginal Message-
From: news [mailto:[EMAIL PROTECTED] On Behalf Of Eric Lilja
Sent: Thursday, December 14, 2006 2:13 PM
To: mysql@lists.mysql.com
Subject: Re: MySQL 5.0.27: character problem
Thanks for the reply, Mr Schwartz. I will see if I can find
some clue on
how to write such a program myse
gards,
> >
> > Jerry Schwartz
> > Global Information Incorporated
> > 195 Farmington Ave.
> > Farmington, CT 06032
> >
> > 860.674.8796 / FAX: 860.674.8341
> >
> >
> >> -Original Message-----
> >> From: news [mailto:[EMAIL
From: news [mailto:[EMAIL PROTECTED] On Behalf Of Eric Lilja
Sent: Wednesday, December 13, 2006 2:03 PM
To: mysql@lists.mysql.com
Subject: MySQL 5.0.27: character problem
Hello, I'm using MySQL version 5.0.27 under Windows XP
professional. I
have a text file with some SQL commands (I create a
sql.com
> Subject: MySQL 5.0.27: character problem
>
> Hello, I'm using MySQL version 5.0.27 under Windows XP
> professional. I
> have a text file with some SQL commands (I create a few tables and
> insert some rows into them). I noticed that all columns where
> I tried to
&
Hello, I'm using MySQL version 5.0.27 under Windows XP professional. I
have a text file with some SQL commands (I create a few tables and
insert some rows into them). I noticed that all columns where I tried to
insert a swedish character, that character got corrupted. But it works
if I type the
