Post by LeeOnline » Thu Feb 26, 2009 9:09 am

Hi, I am currently trying to build my website using the latest version of OpenCart and so far I've translated the catalog files into Spanish and uploaded them, however when I view the site in Spanish, some of the spanish characters are not visible, instead there are little black question mark boxes (firefox) I have tried changing the locale settings in the admin panel and at the moment its at es_US.UTF-8,en_US,spanish I'm not sure if that's right.. I even tried changing the collation to spanish with no change in phpmyadmin, now it is set to utf8_unicode_ci with still no luck.

Anybody have any ideas? It's driving me mad!

p.s. Another thing I noticed is that when I change the language to Spanish on the home page for example, the products dissapear! They are visible in English though...

The site is www.precionet.com

Newbie

Posts

Joined
Thu Feb 26, 2009 9:03 am

Post by liquidpele » Thu Feb 26, 2009 10:09 pm

1) make sure your database table collation is unicode.
2) Make sure the default_charset in php.ini is UTF-8. IF you change it, restart apache.
3) Make sure you save the files as UTF-8, and don't transfer using FTP in ascii mode.

New member

Posts

Joined
Mon Feb 23, 2009 11:58 pm

Post by LeeOnline » Tue Mar 10, 2009 2:27 am

I have tried those 3 options with no success :S

Newbie

Posts

Joined
Thu Feb 26, 2009 9:03 am

Post by liquidpele » Tue Mar 10, 2009 5:30 am

Well... I hate to sound mean, but I think you did something wrong then. If the files are utf-8 and have the characters correctly, and the database is utf-8, and php is set to use utf-8, then it will work with utf-8 character. Note that it will work from then on with utf-8, previously submitted data won't show correctly still because it was saved while utf-8 was not being used.

New member

Posts

Joined
Mon Feb 23, 2009 11:58 pm

Post by nde » Tue Mar 10, 2009 8:37 am

Could be various other things:

a) XML namespace

Code: Select all

<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en" xml:lang="en">
b) Encoding of the browser not set to utf-8 or auto-detect

nde
New member

Posts

Joined
Sat Jun 30, 2007 7:32 am

Post by Hildebrando » Tue Mar 10, 2009 4:46 pm

HI:

Build a distribution with your traslation to spanish and we can work with...

Best,

Hilde

Commercial Contributions:Bulk Specials| Bulk Update Prices|Search Tyre Pro
Free Contributions: Youtube video (oc 1.5.x) | Search History Report (oc 1.5.x) | Product Filter by Category (oc 1.5.x)|Youtube Popup
More Free & commercial mods: www.fpress.com


User avatar
Active Member

Posts

Joined
Fri Mar 06, 2009 8:22 pm
Location - Spain

Post by Hildebrando » Wed Mar 11, 2009 6:44 pm

Hi:

Change in the index.php the line:

$response->addHeader('Content-Type', 'text/html; charset=UTF-8');

with

$response->addHeader('Content-Type', 'text/html; charset=iso-8859-15');

Best,

Hilde

Commercial Contributions:Bulk Specials| Bulk Update Prices|Search Tyre Pro
Free Contributions: Youtube video (oc 1.5.x) | Search History Report (oc 1.5.x) | Product Filter by Category (oc 1.5.x)|Youtube Popup
More Free & commercial mods: www.fpress.com


User avatar
Active Member

Posts

Joined
Fri Mar 06, 2009 8:22 pm
Location - Spain

Post by Hildebrando » Thu Mar 12, 2009 9:01 pm

Hi:

With charset=iso-8859-15 the Eur simbol not see fine... a simple solution is in the database, table currency change the € simbol for the string Eur.

Best,

Hilde

Commercial Contributions:Bulk Specials| Bulk Update Prices|Search Tyre Pro
Free Contributions: Youtube video (oc 1.5.x) | Search History Report (oc 1.5.x) | Product Filter by Category (oc 1.5.x)|Youtube Popup
More Free & commercial mods: www.fpress.com


User avatar
Active Member

Posts

Joined
Fri Mar 06, 2009 8:22 pm
Location - Spain

Post by nde » Fri Mar 13, 2009 5:47 am

Best stick with UTF-8 for websites. When you save the files as UTF-8 and tell the browser iso-8859-15 is coming, then something is wrong...

Using character entitys for special chars is the best method I think.
Standard characters work everywhere, substitute anything above them with html name ID or code:
ã = &atilde; or &#227;
© = &copy; = &#169;
etc...

nde
New member

Posts

Joined
Sat Jun 30, 2007 7:32 am

Post by LeeOnline » Fri Mar 13, 2009 8:23 am

I see what you mean, is there a guide online that can give me an idea of what code applies to certain characters?

Cheers.

Newbie

Posts

Joined
Thu Feb 26, 2009 9:03 am

Post by Nahuel » Fri Mar 13, 2009 9:57 am

You have to use the &aacute; for the accents to work "out of the bok". I had the same problem, and that's the only way to easily fix it.

With the find and replace from Notepad or DreamWeaver, it's done in a few minutes.

á = &aacute;
é = &eacute;
í = &iacute;
ó = &oacute;
ú = &uacute;

New member

Posts

Joined
Fri Mar 13, 2009 9:35 am

Post by Maksymilian » Thu Mar 19, 2009 8:51 pm

Hi Ia have similar problem with polish characters.
But only when I insert text with OpenCart panel.
Can any one tell me how to find coding for polish chars like those in Spanish ?

Regards
Maksymilian

Regards
Maksymilian


Newbie

Posts

Joined
Thu Mar 19, 2009 8:39 pm

Post by Maksymilian » Tue Mar 24, 2009 3:18 pm

Maksymilian wrote:Hi Ia have similar problem with polish characters.
But only when I insert text with OpenCart panel.
Can any one tell me how to find coding for polish chars like those in Spanish ?

Regards
Maksymilian
It seems that after upgrading to var. 1.2 problem is gone.

Regards
Maksymilian


Newbie

Posts

Joined
Thu Mar 19, 2009 8:39 pm

Post by georgekrastev » Tue Jun 16, 2009 3:48 am

Hi,

I am using v1.2.8 with German language and unfortunately the problem still there as well. I think the best case is to convert all files in language/german directory (or whatever language you use) in ASCII format. As editor I use Notepad++ and it support this conversion. Then wherever you need a "special" UTF8 charachters just replace them with a &#<code> (sample &#227 for "ã").

Enjoy,
George

Newbie

Posts

Joined
Wed May 06, 2009 3:43 am

Post by georgekrastev » Tue Jun 16, 2009 3:51 am

Hi,

I am using v1.2.8 with German language and unfortunately the problem still there as well. I think the best case is to convert all files in language/german directory (or whatever language you use) in ASCII format. As editor I use Notepad++ and it support this conversion. Then wherever you need a "special" UTF8 charachters just replace them with a &#<code> (sample &#227 for "ã").
ASCII codes you can find under:
http://ascii.cl/htmlcodes.htm

Enjoy,
George

Newbie

Posts

Joined
Wed May 06, 2009 3:43 am

Post by webmastah » Tue May 25, 2010 11:51 pm

LeeOnline wrote:I see what you mean, is there a guide online that can give me an idea of what code applies to certain characters?

Cheers.
Just Google 'html entities' to see how to implement them in your transation.

Cheers,
David

Image

Opencarter.com
OpenCart Templates


New member

Posts

Joined
Wed May 05, 2010 6:16 pm
Who is online

Users browsing this forum: No registered users and 54 guests