Post by chineseopencart » Sat Oct 25, 2008 10:16 pm

hi Administrator
i add a chinese language pack into v0.78
After i input Chinese character new product, categories, info.... but all Chinese character display ?quition mark.
so i login into mysql data seen data are "?????" coding.
if i input Chinese character into mysql db, they resume correct Chinese characters

it is a bug?? plesase HELP

THX ALL


Posts

Joined
Wed Oct 15, 2008 7:10 pm

Post by david.gilbert » Sat Oct 25, 2008 10:31 pm

your database collation needs to be set to utf8_general_ci

In phpmyadmin run this query

ALTER DATABASE `database_name` COLLATE 'utf8_general_ci';

Professional Website Services - http://www.davidmgilbert.com/


Active Member

Posts

Joined
Sun Jan 06, 2008 5:02 pm
Location - Mount Compass, South Australia

Post by Qphoria » Sat Oct 25, 2008 10:56 pm


Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am
Who is online

Users browsing this forum: No registered users and 139 guests