Post by servispaketi » Fri May 02, 2008 5:39 am

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.
Last edited by servispaketi on Fri May 02, 2008 5:44 am, edited 1 time in total.

Newbie

Posts

Joined
Fri May 02, 2008 4:52 am

Post by bruce » Fri May 02, 2008 7:56 am

The answer is most likely described here. http://forum.opencart.com/index.php/top ... ml#msg3056

Active Member

Posts

Joined
Wed Dec 12, 2007 2:26 pm

Post by servispaketi » Fri May 02, 2008 4:47 pm

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]

Newbie

Posts

Joined
Fri May 02, 2008 4:52 am

Post by bruce » Fri May 02, 2008 6:21 pm

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

Code: Select all

var $expire = 3600;
to

Code: Select all

var $expire = 3;
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
Last edited by bruce on Fri May 02, 2008 6:23 pm, edited 1 time in total.

Active Member

Posts

Joined
Wed Dec 12, 2007 2:26 pm

Post by servispaketi » Fri May 02, 2008 6:48 pm

Dear Bruce,

Thanks alot . You are great !
Last edited by servispaketi on Fri May 02, 2008 7:26 pm, edited 1 time in total.

Newbie

Posts

Joined
Fri May 02, 2008 4:52 am
Who is online

Users browsing this forum: No registered users and 1 guest