Here's what I get when I perform mysql> show variables like "char%";
+--------------------------+---------------------------------+
| Variable_name | Value |
+--------------------------+---------------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | C:\mysql_5.0.27\share\charsets\ |
+--------------------------+---------------------------------+
So it seem my windows character set is utf8 and I need to convert my
scripts from utf8 to latin1 so I can use them properly in MySQL (so
åäöÅÄÖ does not get corrupted), right?
- Eric
Jerry Schwartz skrev:
I did it in PHP, using the iconv() function. I do batches, with the CP1252
(my original message was wrong) files named *.orig. I am doing this to build
web pages, but I think it might serve your purpose with minor modifications.
Note that the PHP folks warned me that PHP is not really UTF-8 safe! So far,
this appears to work; but you might want to use Perl instead. I don't even
know if iconv() supports the character set you want.
There's another possibility, by the way. I seem to recall that you have to
make sure the character set used by the server, the client, and the
connection are what you want (not to mention the data base, the table, and
the fields). Look at this:
mysql> show variables like "char%";
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
7 rows in set (0.03 sec)
In this case, the data base I'm using has a default character set of UTF-8.
I forget if any of these are specific to the mysql command line client. You
can change a bunch of them in one shot with the SET NAMES command in that
client.
Section 10.3.6 of the reference manual (I use the off line version for
speed) discusses this.
Multiple character sets give me a severe headache.
<?php
// This little script searches the current directory for *.orig,
converts from the Windows
// code page to UTF-8, and stuffs the results into the target for use
in the web site
foreach (glob("*.orig") as $file_to_convert) {
$text_to_convert = file_get_contents($file_to_convert);
$text_converted = iconv("cp1252","utf-8",$text_to_convert);
file_put_contents(basename($file_to_convert,".orig"),
$text_converted);
}
?>
Regards,
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: [email protected]
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 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 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,
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: Wednesday, December 13, 2006 2:03 PM
To: [email protected]
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
insert a swedish character, that character got corrupted. But
it works
if I type the same explicitly in mysql monitor. What do I
need to do so
I can use command files and still have proper handling of swedish
characters?
- Eric
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
