Help Database encoding

Forum Moderators: open

Message Too Old, No Replies

Help Database encoding

Problem after moving site

trecords

4:28 pm on Mar 8, 2010 (gmt 0)

Hi,
Please, help me to solve problem on my site, it is productive site and not works last 3 days, i don`t know where to write my help message any more. I wish i will find solution here.
I have Wordpres MU site with Multi-Db plugin, recently i have moved server and after that problems are started. Actually everything works properly, but i there is encoding problem on all blogs. I can save new post properly and they are readable but all old post not shows umlauts of my language. I see only ? . My wp-config uses utf8 charset and collation settings, all databases also in utf8 collation. MySQL connection collation is utf8_general_ci and MySQL charset: UTF-8 Unicode.
Please help me, i am really in trouble.

Thanks,
Turkel.

whoisgregg

10:31 pm on Mar 8, 2010 (gmt 0)

Welcome to WebmasterWorld, trecords!

What was the encoding of the old server? Did you do an export of data from the old server then import it into the new server or did you try and move the data files directly?

trecords

7:47 am on Mar 9, 2010 (gmt 0)

Thanks :)
Actually server admins moved my site, i think they did it with full backup. i don`t know old server configuration, i have no account on old one. My current server configuration from phpmyadmin variables:

Character set client: latin1
Character set connection: latin1
Character set database: latin1
Character set results: latin1
Character set server: latin1
Character set system: utf8
collation connection: latin_swedish_ci
collation database: latin_swedish_ci
collation server: latin_swedish_ci

I don`t know how to change them, but will this variables help me if admins will change them to UTF8.

Thanks.

trecords

1:57 pm on Mar 9, 2010 (gmt 0)

I have submitted ticket and they says these are default configuration of server and these configurations same with old server. I don`t know what to do else, my encoding problem persist also link to my site is:
<snipped url>
? characters must be şçəığö

[edited by: whoisgregg at 4:32 pm (utc) on Mar 9, 2010]
[edit reason] Whoops, no URLs please. See TOS [webmasterworld.com] :) [/edit]

lammert

1:52 am on Mar 11, 2010 (gmt 0)

Converting texts from one charset to another after they have been imported with the wrong charset is a somewhat painful operation in MySQL. The procedure is that you first convert the texts to a binary BLOB object, and then back to the new charset type.

From the MySQL manual [dev.mysql.com]

The CONVERT TO operation converts column values between the character sets. This is not what you want if you have a column in one character set (like latin1) but the stored values actually use some other, incompatible character set (like utf8). In this case, you have to do the following for each such column:

ALTER TABLE t1 CHANGE c1 c1 BLOB;
ALTER TABLE t1 CHANGE c1 c1 TEXT CHARACTER SET utf8;

The reason this works is that there is no conversion when you convert to or from BLOB columns.

trecords

8:12 am on Mar 11, 2010 (gmt 0)

Hi,
Thanks for reply. I have done your command, but the colloumn disappeared after run query. I am too tired too tired, that is vary difficult :( its 6th days my site not works properly.
Is there are any other solution ? I have Navicat, can this tool help me?

Thanks.