Post by jc » Wed Feb 11, 2009 2:23 am

Look at my site: http://www.ntminishop.com

It's in Vietnamese (if not, change to Vietnamese). Notice that strings from db can be displayed nicely, but strings from locale files are all "Cam k?t. Ch�ng t�i cam k?t h�ng h�a ?�ng ch?t l??ng, ?�ng nh� cung c?p v� cam k?t giao h�ng khi Qu� kh�ch ??t h�ng."

I have tried do these things to fix it:

- Used and but it cant help.

- I also converted all php and tpl files to utf-8 too. NOT WORK! >:(

Help! Thanks in adv.

jc
Newbie

Posts

Joined
Sun Feb 08, 2009 3:02 pm

Post by Daniel » Wed Feb 11, 2009 3:10 am

I'm releasing a fix tonight.

change;

mysql_query("SET CHARACTER SET utf8", $this->link);

to

mysql_query("SET NAMES 'utf8'", $this->link);
mysql_query("SET CHARACTER SET utf8", $this->link);

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by jc » Wed Feb 11, 2009 12:29 pm

Oh, those texts from db is good. It just can't display UTF-8 from language files.

jc
Newbie

Posts

Joined
Sun Feb 08, 2009 3:02 pm

Post by jc » Wed Feb 11, 2009 12:45 pm

And really strange is this only occurs on linux host. It displayed well on wins.

jc
Newbie

Posts

Joined
Sun Feb 08, 2009 3:02 pm

Post by JNeuhoff » Wed Feb 11, 2009 6:32 pm

Your site works fine, justed tested it using Firefox 3.0.5 on Ubuntu 8.10.

Attachments

???
ntminishop.png

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by jc » Wed Feb 11, 2009 6:41 pm

Oh, I can't wait for the answer, so I used &#XXXX; type to temporary solve it. :(

You can try it by type some utf8 characters into language files and host it on a linux server. They all changed to �����...

jc
Newbie

Posts

Joined
Sun Feb 08, 2009 3:02 pm

Post by JNeuhoff » Wed Feb 11, 2009 8:28 pm

Just tested it on my Linux server, and it works fine there, too.

Maybe your Linux webserver hasn't been correctly configured?

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am

Who is online

Users browsing this forum: No registered users and 11 guests