Forum Moderators: open

Message Too Old, No Replies

My site doesn't display Chinese characters from SQL

What should i do?

         

rowtc2

6:47 pm on Nov 4, 2008 (gmt 0)

10+ Year Member



I have some articles translated in Chinese.When i am importing sql file with chinese characters, in database there are ? characters instead Chinese letters.Also, i try to enter in phpMyadmin and edit an article. I copy chinese article in text area and click Save/Go. But is an error:
Warning: #1366 Incorrect string value: '\xE6\xB5\x8F\xE8\xA7\x88...' for column 'description' at row 1

I changed collation for a row in gbk_chinese_ci or gb2312_chinese_ci and now is working to save chinese letters.
In metatags i have
<meta http-equiv="Content-Language" content="zh-tw">
<meta HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=big5">
My site display a lot of ? instead chinese characters updated succesfully in phpmyadmin.

What i should do to display with chinese characters ? (some words from articles are still in English because cannot be translated in chinese ex: George Bush)
-my browser see chinese letters from chinese sites.

physics

12:43 am on Nov 6, 2008 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Question about he sites you visit with working chinese characters:
Do they have the same meta tags?