Can not search Chinese input in database.

[cn000]

I am using Chinese simplified gb2312 on my site. But I have issue with search chinese input. When I switched to English iso-8859-1, the search works fine. I think it might be the mySQL database is using UTF-8. I tried a lot of ways to convert the chinese input to UTF-8.. But no success. Can anyone provide some information on this?

 

My question is

 

1. How can I convert the chinese input to something database would recongnize?

2. Do I need to change the database, although this is the last thing I want to do?

 

 

Much appreciated.

 

Thanks.

[derrickw]

I am using Chinese simplified gb2312 on my site. But I have issue with search chinese input. When I switched to English iso-8859-1, the search works fine. I think it might be the mySQL database is using UTF-8. I tried a lot of ways to convert the chinese input to UTF-8.. But no success. Can anyone provide some information on this?

 

My question is

 

1. How can I convert the chinese input to something database would recongnize?

2. Do I need to change the database, although this is the last thing I want to do?

Much appreciated.

 

Thanks.

 

Is anyone found the solution on this?

[madauska]

I have the same problem, can anyone help?

[justzforever]

same issue,

 

Please let me know if you got it fix. i'll do the same.

[uckc]

BEFORE YOU TRY THIS, remember to backup!

 

Try using this to convert your files from GB3212 to UTF-8:

http://www.softpedia.com/get/System/File-M...Converter.shtml

 

THEN, remember to change the charset to utf-8 in the main language file (ie. chinese.php).

Edited July 7, 2009 by uckc

[tgely]

I am using Chinese simplified gb2312 on my site. But I have issue with search chinese input. When I switched to English iso-8859-1, the search works fine. I think it might be the mySQL database is using UTF-8. I tried a lot of ways to convert the chinese input to UTF-8.. But no success. Can anyone provide some information on this?

 

My question is

 

1. How can I convert the chinese input to something database would recongnize?

2. Do I need to change the database, although this is the last thing I want to do?

 

 

Much appreciated.

 

Thanks.

 

My opinion:

 

1. utf-8 standard contains gb2312 standard? If it is not it is very difficult. You have to make an input-output encoder from gb2312 to utf-8 and versus. Probably the typed characters into search field not equals the utf-8 charset definitions in html area.

Get an gb2312 codepage and utf-8 hexa converter.

 

 

2. Have you translated english/ISO-8859-1 products name to chinese/gb2312 language or do you use only english names?

If not, translate and have to work. When you make translate use gb2312 charset in your browser and better you use compatible keyboard. Chinese area probably use gb2312 keyboard sets and they couldn't type in the correct characters. It could be differencies.

 

 

3. Get typed characters!

 

Get a mail with gb2312 charset for example tell-e friend and look at the hexa codes of characters. Make a comparation with utf-8 characters hexa codes and gb2312 letter character codes. Concentrate only iso-8859-1 charsets. If it differents you need to encode.

 

In the recived mail you can make a pair to typed characters. A= ; B=; ...... to the end of ISO-8859-1 charset between gb2312 charset typed characters hexa codes.

 

I have just similar problems to make osC3 translations in mail sending process. Try to see the better ISO/UTF-8 mail 1.0 contrib. In the mail.php you can see an database table nativ special_encoder and mail hexa fisher. I dont use it now, because I find a better ways to solve in 2.0. In my future plain I would like to do an SQL file translate encoder for osc. It would be good every same problems. See you later if you cant solve.