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
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
BG'08
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.
the discription is without lithuanian letters..
and here is example from mysql:
Code: Select all
5 2 H1-H13 <p>vėjas</p>
i write you pm with my logins.
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.
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.
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.
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.
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.
sorry for my english.
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: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? :/
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.
Last edited by mrtwisteryu on Fri Sep 12, 2008 6:55 am, edited 1 time in total.
Who is online
Users browsing this forum: No registered users and 20 guests