Hello to Everybody,
I installed Open Cart 0.77. Everything on the pages is correct. But I am meeting the problem of turkish alphabetical character in the fields (such as, products, product contents, store informations, category names) and whatever i did , i couldnt solve this problem.
What must i do to solve this problem ?
Thank you in advance for your assistance .
http://img241.imageshack.us/img241/6323/opcartwa8.jpg[/img]
Herkese Merhaba,
Open Cart 0.77 kurdum. Sayfalarda her şey yerinde ve düzgün. Fakat admin panelinden eklediğim ürünler, ürün açıklamaları, dükkan bilgileri, kategori isimleri gibi alanlarda türkçe karakter problemi yaşıyorum ve ne yaptıysam bu sorunu çözemedim.
Bu konuyu çözmek için nasıl hareket etmeliyim.
Konuyla ilgili destekleriniz için teşekkür ederim.
The answer is most likely described here. http://forum.opencart.com/index.php/top ... ml#msg3056
Dear Bruce, thanks for your assistance. I have applied all. But the problem couldnt be saved. I Can tell you like this :
------------------------------------------------------------------------------------------
when there is no the mysql_query("SET NAMES 'utf8'"); line in database.php , it is appearing like this :
http://img340.imageshack.us/img340/8245 ... cesmi3.jpg[/img]
------------------------------------------------------------------------------------------
when there is the mysql_query("SET NAMES 'utf8'"); line in database.php , it is appearing like this :
http://img340.imageshack.us/img340/6175 ... likwi9.jpg[/img]
------------------------------------------------------------------------------------------
the conditions on the pages
http://img340.imageshack.us/img340/2231 ... tf8mq1.jpg[/img]
------------------------------------------------------------------------------------------
http://img340.imageshack.us/img340/5310 ... 254pv7.jpg[/img]
------------------------------------------------------------------------------------------
when there is no the mysql_query("SET NAMES 'utf8'"); line in database.php , it is appearing like this :
http://img340.imageshack.us/img340/8245 ... cesmi3.jpg[/img]
------------------------------------------------------------------------------------------
when there is the mysql_query("SET NAMES 'utf8'"); line in database.php , it is appearing like this :
http://img340.imageshack.us/img340/6175 ... likwi9.jpg[/img]
------------------------------------------------------------------------------------------
the conditions on the pages
http://img340.imageshack.us/img340/2231 ... tf8mq1.jpg[/img]
------------------------------------------------------------------------------------------
http://img340.imageshack.us/img340/5310 ... 254pv7.jpg[/img]
Try each test with Firefox browser and IE. Note that the admin site will go to turkish if the store is set to turkish.
Ensure that the set names code is in place as previously suggested.
Temporarily change the line
to
in the file library\cache\cache.php This makes the cache expire after 3 seconds and will stop the cache from messing up the tests.
Now try editing a category description in turkish.
Have a look in the database table category_description and see if the data there is correct. The set names should ensure that it is. However, this link describes other issues with character encoding and is worth reading. http://www.oreillynet.com/onlamp/blog/2 ... in1_t.html
If not, enter the correct value directly into the database table and check the store from your web browser.
You must also ensure that the language files you create are saved from your text editor as utf-8.
Have a look at the collation and encoding of the database using phpmyadmin or equivalent.
Also you might try this which seems kind of opposite but worked for someone else http://forum.opencart.com/index.php/top ... ml#msg3065
Ensure that the set names code is in place as previously suggested.
Temporarily change the line
Code: Select all
var $expire = 3600;
Code: Select all
var $expire = 3;
Now try editing a category description in turkish.
Have a look in the database table category_description and see if the data there is correct. The set names should ensure that it is. However, this link describes other issues with character encoding and is worth reading. http://www.oreillynet.com/onlamp/blog/2 ... in1_t.html
If not, enter the correct value directly into the database table and check the store from your web browser.
You must also ensure that the language files you create are saved from your text editor as utf-8.
Have a look at the collation and encoding of the database using phpmyadmin or equivalent.
Also you might try this which seems kind of opposite but worked for someone else http://forum.opencart.com/index.php/top ... ml#msg3065
Last edited by bruce on Fri May 02, 2008 6:23 pm, edited 1 time in total.
Dear Bruce,
Thanks alot . You are great !
Thanks alot . You are great !
Last edited by servispaketi on Fri May 02, 2008 7:26 pm, edited 1 time in total.
Who is online
Users browsing this forum: No registered users and 1 guest