Post by jd » Fri Aug 31, 2007 4:11 pm

Hi,

I have some issues with Cyrillic support. When I enter a new title for let's say terms of use, in Cyrillic, I get the following error and cannot move forward:
* Information Title must be greater than 3 and less than 64 characters!

Any ideas how to correct it?

Also, when I put the products with descriptions in English and in Bulgarian, I don't get the same products in the different language version of the catalog. Please help.

jd
Newbie

Posts

Joined
Fri Aug 31, 2007 2:57 pm

Post by jd » Sun Sep 02, 2007 11:30 pm

anyone?

jd
Newbie

Posts

Joined
Fri Aug 31, 2007 2:57 pm

Post by Daniel » Mon Sep 03, 2007 4:32 am

jd wrote: anyone?
You need to change the length of the feild in the dataabse and int he controller. Let me know what you recommend as field size for future releases.

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by jd » Tue Sep 04, 2007 8:37 pm

10x. Sorry for asking, but in which table and which field this is in the DB?
And where do I change the controller?

jd
Newbie

Posts

Joined
Fri Aug 31, 2007 2:57 pm

Post by petpetep » Sat Sep 08, 2007 3:12 pm

this problem is when we wrote something in cyrillic for example admin-catalog-localization-currency and code is in cyrillic ...

New member

Posts

Joined
Sat Aug 11, 2007 4:19 pm


Post by Daniel » Sat Sep 08, 2007 7:03 pm

petpetep wrote: this problem is when we wrote something in cyrillic for example admin-catalog-localization-currency and code is in cyrillic ...
I'm not sure how to solve this problem. I have little experiance with multiple languages. I have been leaving the character set change to scandic.

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by petpetep » Sun Sep 09, 2007 12:30 am

i think that the problems comes with this that not all opencart is avaliable in other languages and when we use something in english all is ok, but when other language ....

this with thing with minimum 3 characters i found a decision in notepad ++ :) wrote this thing in utf format and than choose ansi :) -> copy + past :)

New member

Posts

Joined
Sat Aug 11, 2007 4:19 pm


Post by mirkov » Mon Sep 17, 2007 6:00 am

BG
Отвори library/database/database.php
Търси:

Code: Select all

mysql_query("set character set utf8");
Замени го с:

Code: Select all

mysql_query("set character set cp1251");
Мисля че проблемът ти ще се реши.

ENG:
Open up library/database/database.php
Search for:

Code: Select all

mysql_query("set character set utf8");
And change it to:

Code: Select all

mysql_query("set character set cp1251");
I thing that this is your problem.

Good luck :)

Newbie

Posts

Joined
Mon Sep 17, 2007 5:57 am

Post by petpetep » Mon Sep 17, 2007 6:50 pm

ами проблема се оказа доста странен, аз си го реших, но се оказа, че утф-а на кирилица приема по-малко кирилски букви от латинските :) от настройките за ограничение на броя символи промених горната граница.

още не съм сигурен дали да не променя изобщо кодировката в следващите версии

New member

Posts

Joined
Sat Aug 11, 2007 4:19 pm


Post by azzzy » Tue Sep 18, 2007 2:20 am

UTF-8 is a variable length encoding, ranging from 1 to 4 bytes per char. US ASCII chars takes one, accented or special character from Western and Eastern European needs 2 bytes per char, Cyrillic, Greek and Turkic chars also. Therefore the limit of 64 characters means 32 if you use Cyrillic (if we don't count spaces and punctuation, which are the same as the US ASCII ones, and actually uses only one byte).
I recommend increasing the length of the varchar fields, and continuing with UTF8, which can solve you a lot of issues if you whant to go multilanguage some day.

In all versions of MySQL above 4.1 this is solved, and varchar(n) means n characters in the selected encoding, not n bytes.

Newbie

Posts

Joined
Wed Sep 12, 2007 6:55 pm
Who is online

Users browsing this forum: No registered users and 4 guests