Zen Cart Logo
Forums / Addon Language Packs / category name length problem in Hebrew

category name length problem in Hebrew

Locked

Views: 2,476

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
5 Nov 2008, 8:32 PM
#1
eglantin avatar

eglantin

New Zenner

Join Date:
Nov 2008
Posts:
4
Plugin Contributions:
0

category name length problem in Hebrew

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.

16 Nov 2009, 9:50 AM
#2
greeny avatar

greeny

New Zenner

Join Date:
May 2009
Posts:
2
Plugin Contributions:
0

Re: category name length problem in Hebrew

  1. open your DB ( I open it with phpMyAdmin)
  2. select table categories_descriptions
  3. and edit the table structure - field:categories_name
  4. change the length of categories_name varchar from 32 to the length you need ( I changed it to 128)
  5. retype your categories Hebrew names in your zen cart admin