[ic] utf-8 problem

Alessandro Poletto pollok at gmail.com
Sun Nov 9 23:42:01 UTC 2008

I've a problem with utf-8 charset.

The error starts from the administration in which I have the customers
datas, some days ago a french man have signed and the address have
some accent chars (è and é).

So if I go into the admin and I change something the result will seems
ok ad the customer_all.html but if I go into the "shipping address"
and I try to change the data all the accent has been replaced from
strange chars.

I've tested that into the db the datas is bad encoded, but
customer_all.html show me perfectly.

I've made some modification to catalog.cfg trying to fix the problem:
Variable MV_CHARSET utf-8
Variable MV_UTF8        1

I've inserted
 DatabaseDefault MYSQL_ENABLE_UTF8
into dbconf/mysql/mysql.cfg

and finally I've inserted
    AddDefaultCharset UTF-8
into the apache virtual host definition

Now I've nothing more to do and I haven't any other ideas... Its seems
that the browser send datas, the cgi take it and convert showing
correctly but into the normal text filed into the amministration
something works differently! Another info is that i've put the
collection on mysql db, table and field in utf8_unicode_ci.

Many thanks to everyone can help me, is really important for me.

More information about the interchange-users mailing list