Hi there,
I'm in the process of creating an eshop in Greek and am running into the following problem which should apply to other languages as well:
After installing zen-cart (1.3.7), I enter the admin page and enter a new product. I type in a short product name in greek which works fine.
If however I try to type in a slightly longer product name (which normally would work in English), the following error comes up:
Now, based on the below forum post, apart from creating a language pack, I shouldn't need to make any other changes to the database or zen-cart:1406 Data too long for column 'products_name' at row 1
in:
[update products_description set products_name = 'ασδφσδφφσαδφασδφασδφ', products_description = 'asdfasdf', products_url = '' where products_id = '181' and language_id = '2']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
However, based on the language pack for UTF-8 from the zen-cart pageHTML Code:http://www.zen-cart.com/forum/showthread.php?t=32267&highlight=utf-8+greek
I also need to add:HTML Code:http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_46&products_id=601to query-factory.phpCode:if (version_compare(mysql_get_server_info(), '4.1.0', '>=')) { mysql_query('SET NAMES "utf8"', $this->link);}
When I try to do this and install zen-cart I get the following error:
1366 Incorrect string value: '\xA3:&eur...' for column 'configuration_value' at row 1
in:
[INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Convert currencies for Text emails', 'CURRENCIES_TRANSLATIONS', '£,£:€,€', 'What currency conversions do you need for Text emails?
Default = £,£:€,€', 12, 120, NULL, '2003-11-21 00:00:00', NULL, 'zen_cfg_textarea_small(');]
Has anyone come across this before? Any help at all is greatly appreciated.
Alex
Bookmarks