category name length problem

[Eglantin]

Hi,

I am trying to add a category in hebrew. When I enter a name (in the hebrew `Category Name` field) that consists of more than 4 hebrew characters, I get the following error:

1406 Data too long for column 'categories_name' at row 1
in:
[update categories_description set categories_name = 'נסיון', categories_description = 'בלה בלה בלה' where categories_id = '77' and language_id = '2']

If the category name is english only, then, there is no problem, even if the category name consists of english AND hebrew characters (For example: נסיוtry) it still works. The problem arises just when I use only hebrew characters.

Does anybody have a suggestion for a solution?

Thanks,
Noa.

[czepp]

I had the same issue with thai. I had to update size of the columns in the database. Here are the columnss i changed from VARCHARR(32) to VARCHAR(256)


U need to do this in myphpadmin in an sql window with your store database selected (assumung that u are usung mysql and have myphpadmin avail);


[FONT="Courier New"]
ALTER TABLE products MODIFY products_model varchar(256) ;
ALTER TABLE products_description MODIFY products_name varchar(256) ;
ALTER TABLE address_book MODIFY entry_firstname varchar(256) ;
ALTER TABLE address_book MODIFY entry_lastname varchar(256) ;
ALTER TABLE categories_description MODIFY categories_name varchar(256) ;
ALTER TABLE configuration_group MODIFY configuration_group_title varchar(256) ;
ALTER TABLE customers_wishlist MODIFY products_name varchar(256) ;
ALTER TABLE customers_wishlist MODIFY wishlist_name varchar(256) ;
ALTER TABLE files_uploaded MODIFY files_uploaded_name varchar(256) ;
ALTER TABLE orders MODIFY customers_name varchar(256) ;
ALTER TABLE orders MODIFY customers_email_address varchar(256) ;
ALTER TABLE orders MODIFY delivery_name varchar(256) ;
ALTER TABLE orders MODIFY billing_name varchar(256) ;
ALTER TABLE orders MODIFY cc_owner varchar(256) ;
ALTER TABLE orders_products MODIFY products_name varchar(256) ;
ALTER TABLE orders_products MODIFY products_model varchar(256) ;

[/FONT]

[czepp]

Also check the utf8 tutorial!!!
http://www.zen-cart.com/forum/showth...collation+utf8