We are using OSCommerce Ver.2.2 and MySQL ver. 5.0. The servers are from a hosting service in the U.S (eg. Yahoo, Godaddy, etc.). We need to have Chinese working on our modified OSC store without affecting the overall functionality of OSC.
It will be more complicated than just modifying the language folders. We have modified our database to fit our needs of updating 5000+products a day. The product information are directly sent to our database from the supplier in UTF-8. The original tables (eg. categories, products, manufacturers, etc.) are actually VIEW (as in MySQL 5.0 new VIEW function) modified from the product information. This way, we can update our product information in real time. The problem we are having is the UTF-8 shows up as ??? on the webpages. Other static text (eg. about us, contact us, etc.) have no problems, it is the updated product information and the categories that we would like working on.
