Eric,
I think that you don't have to write a conversion program because MySQL
have built-in pretty good character set conversions. All you need to do
is to tell MySQL which character set uses your file with your SQL
commands. Create your file with one of the character sets MySQL
understands
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
ards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: news [mailto:[EMAIL PROTECTED] On Behalf Of Eric Lilja
> Sent: Thursday, December 14, 2006 2:13 PM
> To: mysql@lis
Thanks for the reply, Mr Schwartz. I will see if I can find some clue on
how to write such a program myself.
- Eric
Jerry Schwartz skrev:
I have run into this as well. Windows uses CP-1522 (if I remember
correctly), which is not exactly equivalent to UTF-8. I presume it is also
not exactly eq
I have run into this as well. Windows uses CP-1522 (if I remember
correctly), which is not exactly equivalent to UTF-8. I presume it is also
not exactly equivalent to the character set you're using for MySQL. I wound
up writing a program to convert the one character set to the other.
Regards,
Jer