Encoding problems with database

[mobetta]

Hi,

 

The site that I am working on is by default Japanese language. The display text on the page displays properly in S-JIS encoding but the problem is when a customer inputs something into a textbox.

 

The catalog search function doesn't work when you search in Japanese and when a customer inputs Japanese text into their account information, it doesn't save in the right encoding. In the admin panel it just shows as illegible ASCII characters from the Western ISO-8859-1 charset.

 

I am pretty sure that this is a database problem and a simple fix. I need to change the database's encoding method to Japanese (EUC-JP) or (S-JIS).

 

This problem shouldn't just be isolated to Japanese either it will apply to all non-Western charset languages like Arabic and Russian.

 

So the main question is how do I change the encoding method in the database with phpMyAdmin?

 

Thanks in advance!

[Guest]

I think you need to check your sites encoding. All the Japanese sites we have set up have been defaulting to EUC encoding.

 

To see what is really going on, I suggest you use myphpadmin to look at the actual data saved. Note you will have to work in Japanese and set the encoding.