Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2008
    Posts
    4
    Plugin Contributions
    0

    Default 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.

  2. #2
    Join Date
    May 2009
    Posts
    2
    Plugin Contributions
    0

    Default 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

 

 

Similar Threads

  1. Changing Length of Category Name
    By Peter_AimImports in forum Templates, Stylesheets, Page Layout
    Replies: 3
    Last Post: 11 Dec 2012, 09:08 PM
  2. Merchant-Category Name length
    By DarkAngel in forum Basic Configuration
    Replies: 2
    Last Post: 27 Dec 2011, 02:06 AM
  3. category name max length
    By nrfy in forum Templates, Stylesheets, Page Layout
    Replies: 12
    Last Post: 16 Feb 2010, 10:49 AM
  4. category name length problem
    By Eglantin in forum Setting Up Categories, Products, Attributes
    Replies: 2
    Last Post: 8 Nov 2008, 07:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR