homepage Welcome to WebmasterWorld Guest from 23.22.194.120
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Help Database encoding
Problem after moving site
trecords




msg:4093363
 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




msg:4093610
 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




msg:4093795
 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




msg:4093975
 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 &#351;&#231;&#601;&#305;&#287;&#246;

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

lammert




msg:4095103
 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




msg:4095221
 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.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved