OpenCart Community

Hi. I added lithuanian language in my site. but when i write product description in lithuanian, at shop page the system doesnt recognise letters..it became "??" ... what i could change to make it work? :/

Fix your database collation...

PhpMyAdmin -> and fix your table, or just drop it and create another one... Use utf8_general_ci and you would not have a problem with cyrillic characters, i am from Bulgaria and my language is cyrillic as well so ... Also check your connection collation so it is set to utf8 as well

which encoding you are using in your language script? i mean in this shop/catalog/language/bulgarian/bulgarian.php

can somebody help me with this shit error...i must build my page! :/

You are going to have to check each step in the process to see where it becomes broken.

The first place is the data saved in the product description in the database, to see if it is stored as the correct characters.

yes, everything is correct in data base (mysql) but in the letter or in the shop page no lithuanian characters..(i mean product info and payment confirm.)..

I had a look around the sites you gave me but cannot be sure that I am looking at the problem. Could you set up a demonstration, specify the database and store urls and I will go back again.

http://fresheris.webhosting4free.info/s ... oduct_id=5

the discription is without lithuanian letters..

and here is example from mysql: the word vėjas is with normal lithuanian characters but the shop page isnt able to recognise it..

i write you pm with my logins.

any progress?

Its not the database. I can paste the values into the database and they look ok.

As for the rest, I am sorry but I do not know. What is interesting is that the values from the language files display ok, so it is not any html headers or the css that are causing the problem. Hence, it is likely that the database connection messes them up. Another reason for thinking this is that if I try to save the lithuanian letters from the admin pages, they are corrupted in the database.

Over to you.

thanks man. i also think that the problem is somewhere between admin panel and database... somewhere in scripts.. shit how to correct everything :/  i am going crazy

Yeah, I am not surprised. Everything that can go wrong seems to have landed on you.

I do not believe it is in the scripts or the admin. Remember that the text from the language files is displaying ok. I can get the correct text into the database using phpmyadmin. It is only if we try to send the text to the database from the admin or to display the (correct text) from the database that it goes wrong. Hence, I suspect that the corruption is somehow occurring during transport to and from the database.

yech... maybe i should try another server? it tried to use ascii codes and it worked (manualy added to database).. something misterouse...

solution???

i was changed the chartset to windows-1257 in lithuanian.php file. but the problem was in saving translated files. as i was editing them by notepad after saving, they saved as "ANSI" encoding. i changed it to UTF-8 , also changed the charset to utf8 in language file. No problems know! to sum it up: after translating files with notepad dont forget to save it with utf-8 encoding.

sorry for my english.

no worries about your english.. 100% good..  and thanks for the answer..  that could prove to be troublesome and good to have documented here


thanks
Luvz2drv

Fresher wrote: Hi. I added lithuanian language in my site. but when i write product description in lithuanian, at shop page the system doesnt recognise letters..it became "??" ... what i could change to make it work? :/

I had the same issue (with Serbian letters) and adding mysql_query("set names 'utf8'"); to the database.php file resolved the problem. You should add it in function connect with the other two queries. The location of the database.php is:

SHOP_DIRECTORY\library\database

cheers


edit: you should also modify order.php from the SHOP_DIRECTORY\library\cart\ folder. Add following piece of code:

$order_info = preg_replace('!s:(\d+):"(.*?)";!se', "'s:'.strlen('$2').':"$2";'", $order_info );

to the function load($reference) before the next line:

$this->data      = unserialize($order_info['data']);

And that should prevent some "Cannot modify header information.." warnings.

And, as someone already wrote: after translating files with notepad don't forget to save it with utf-8 encoding without bom.