Charset error after upgrade

1-19-05, 08:14 AM

After the server upgrade I am having problems creating new records with chinese char strings.

I had a quick discussion with the 1-1 chat site op and we studied a few forum posts and MySQL documents, but still cannot fix my problem.

I come across this documentation in MySQL http://dev.mysql.com/doc/mysql/en/Charset-MySQL.html and it appears that I will need the charset big5 with collation big5_chinese_ci for my chinese pages to work agian. This does not seem to be available after the upgrade.

Does anyone have similar problem? or just anything to shine some lights on how to fix this?

Currently my page is filled with ??? and trust me, it's not a pretty sight/site!!!!

Thanks in advance.

HalfaBee · 1-19-05, 08:41 AM

I would suggest you try http://phpmyadmin.powweb.com and check the collation col. of your DB is set to the correct language.

1-19-05, 06:07 PM

Thanks HalfaBee.

Sorry it wasn't clear but this is what Iam saying, the collation I need is big5_chinese_ci but it is not available on the list.

If anyone knows what other collation is compatible for big5 chinese characters please let me know. From what I see in the available list is mainly european lauguages, not asian.

mjp · 1-19-05, 06:18 PM

If you get a you get a "table not found error" you may have to do some tweaking to your database, as character support has changed in MySQL 4.1:
http://dev.mysql.com/doc/mysql/en/Up...-from-4.0.html
http://dev.mysql.com/doc/mysql/en/Ch...onversion.html

1-19-05, 08:37 PM

Thanks mjp. but no, I am not getting the table not found error.

The tables are fine, the old records are fine. But when I create new records, it cannot save my chinese text but "???" or monster code instead.

More ideas?

1-21-05, 08:36 AM

I also have the error

text but "???" or monster code instead

the support of powweb please must help this error

4-23-05, 12:08 AM

me too
text but "???" or monster code instead
the support of powweb please must help this error

4-30-05, 02:40 AM

I am migrating from other host, have the same problem.
The charset of my database is utf-8. After setting collation to utf8-general-ci, I can restore the data base correctly.
The content can be shown readable in phpmyadmin, but on webpage they become ???s. I use WordPress.
Look forward your ideas?

Dan Lu · 7-17-05, 05:58 AM

I met the same problem. No solution?
It's strange!
I find the "big5_chinese_ci ", but still don't work.
One another hosting, there is "Big5" language selection in phpMyAdmin 2.61,
and it works well.

Dan Lu · 7-28-05, 08:26 AM

mmmh..
May I ask hosting master add the language Big5 for Big5 user?

8-3-05, 03:56 PM

I encountered the exact same problem as yanfeng described when migrating my wordpress website. And then I found the solution at yanfeng's website. http://yanfeng.org/blog/585/ It's in Chinese. I translate it here:

To solve this problem, the wp-includes/wp-db.php has to be modified. Add the line
Code:
   $this->query(”SET NAMES ‘utf8′”);
right after
Code:
$this->dbh = @mysql_connect($dbhost,$dbuser,$dbpassword); 
so the resulting code should be:
Code:
    $this->dbh = @mysql_connect($dbhost,$dbuser,$dbpassword);
    //add this line
    $this->query(”SET NAMES ‘utf8′”);

8-9-05, 04:26 AM

Parse error: parse error, unexpected T_STRING in /home/cuaut2/public_html/blogs/wp-includes/wp-db.php on line 44

Got this error.

what to do?

on line 44 is $this->query(”SET NAMES ‘utf8′”);

**IanS** · 8-9-05, 05:26 AM

Quote:

Originally Posted by coolnalu

Parse error: parse error, unexpected T_STRING in /home/cuaut2/public_html/blogs/wp-includes/wp-db.php on line 44

Got this error.

what to do?

on line 44 is $this->query(”SET NAMES ‘utf8′”);

The string quoted doesn't look like it's from a powweb installation. Powweb doesn't use home or public_html - check that you've installed the application correctly and supplied paths correctly for a powweb installation.

1-19-05, 08:14 AM	#1
see_why_you Posts: n/a	Charset error after upgrade After the server upgrade I am having problems creating new records with chinese char strings. I had a quick discussion with the 1-1 chat site op and we studied a few forum posts and MySQL documents, but still cannot fix my problem. I come across this documentation in MySQL http://dev.mysql.com/doc/mysql/en/Charset-MySQL.html and it appears that I will need the charset big5 with collation big5_chinese_ci for my chinese pages to work agian. This does not seem to be available after the upgrade. Does anyone have similar problem? or just anything to shine some lights on how to fix this? Currently my page is filled with ??? and trust me, it's not a pretty sight/site!!!! Thanks in advance.

1-19-05, 08:41 AM	#2
HalfaBee Join Date: Feb 2002 Location: Sydney, Australia Posts: 7,131 Reputation: 333	I would suggest you try http://phpmyadmin.powweb.com and check the collation col. of your DB is set to the correct language. __________________ I don't suffer from laziness, I enjoy every minute! Edit your php.ini here http://members.powweb.com/member/cgi...nt/PHPplus.bml

8-3-05, 03:56 PM	#11
haihaowu Posts: n/a	I encountered the exact same problem as yanfeng described when migrating my wordpress website. And then I found the solution at yanfeng's website. http://yanfeng.org/blog/585/ It's in Chinese. I translate it here: To solve this problem, the wp-includes/wp-db.php has to be modified. Add the line Code: $this->query(”SET NAMES ‘utf8′”); right after Code: $this->dbh = @mysql_connect($dbhost,$dbuser,$dbpassword); so the resulting code should be: Code: $this->dbh = @mysql_connect($dbhost,$dbuser,$dbpassword); //add this line $this->query(”SET NAMES ‘utf8′”);

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

1-19-05, 06:07 PM	#3
see_why_you Posts: n/a	Thanks HalfaBee. Sorry it wasn't clear but this is what Iam saying, the collation I need is big5_chinese_ci but it is not available on the list. If anyone knows what other collation is compatible for big5 chinese characters please let me know. From what I see in the available list is mainly european lauguages, not asian.

1-19-05, 06:18 PM	#4
mjp on hiatus Join Date: Nov 2002 Location: Up your *** Posts: 2,864 Reputation: 203	If you get a you get a "table not found error" you may have to do some tweaking to your database, as character support has changed in MySQL 4.1: http://dev.mysql.com/doc/mysql/en/Up...-from-4.0.html http://dev.mysql.com/doc/mysql/en/Ch...onversion.html

1-19-05, 08:37 PM	#5
see_why_you Posts: n/a	Thanks mjp. but no, I am not getting the table not found error. The tables are fine, the old records are fine. But when I create new records, it cannot save my chinese text but "???" or monster code instead. More ideas?

1-21-05, 08:36 AM	#6
evaland Posts: n/a	I also have the error text but "???" or monster code instead the support of powweb please must help this error

4-23-05, 12:08 AM	#7
maso Posts: n/a	me too text but "???" or monster code instead the support of powweb please must help this error

4-30-05, 02:40 AM	#8
yanfeng Posts: n/a	I am migrating from other host, have the same problem. The charset of my database is utf-8. After setting collation to utf8-general-ci, I can restore the data base correctly. The content can be shown readable in phpmyadmin, but on webpage they become ???s. I use WordPress. Look forward your ideas?

7-17-05, 05:58 AM	#9
Dan Lu Registered Join Date: Mar 2004 Location: Taipei Posts: 14 Reputation: 5	I met the same problem. No solution? It's strange! I find the "big5_chinese_ci ", but still don't work. One another hosting, there is "Big5" language selection in phpMyAdmin 2.61, and it works well.

7-28-05, 08:26 AM	#10
Dan Lu Registered Join Date: Mar 2004 Location: Taipei Posts: 14 Reputation: 5	mmmh.. May I ask hosting master add the language Big5 for Big5 user?

8-9-05, 04:26 AM	#12
coolnalu Posts: n/a	Parse error: parse error, unexpected T_STRING in /home/cuaut2/public_html/blogs/wp-includes/wp-db.php on line 44 Got this error. what to do? on line 44 is $this->query(”SET NAMES ‘utf8′”);