OSCOMMERCE SUPPORT CALL 702-453-3332

Help - Search - Members - Calendar

Full Version: Can not search Chinese input in database.

osCommerce Community Support Forums > osCommerce Online Merchant v2.x > Contributions / Add-Ons > Languages and Zones

cn000

Mar 2 2007, 06:01 AM

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

Oct 17 2007, 05:48 AM

QUOTE (cn000 @ Mar 2 2007, 02:01 PM)

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

Nov 8 2007, 06:07 PM

I have the same problem, can anyone help?

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Invision Power Board © 2001-2008 Invision Power Services, Inc.

osCommerce Community Support Forums > Can not search Chinese input in database.

OSCOMMERCE SUPPORT CALL 702-453-3332

Help - Search - Members - Calendar

Full Version: Can not search Chinese input in database.

osCommerce Community Support Forums > osCommerce Online Merchant v2.x > Contributions / Add-Ons > Languages and Zones

cn000

Mar 2 2007, 06:01 AM

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

Oct 17 2007, 05:48 AM

QUOTE (cn000 @ Mar 2 2007, 02:01 PM)

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

Nov 8 2007, 06:07 PM

I have the same problem, can anyone help?

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Invision Power Board © 2001-2008 Invision Power Services, Inc.