Forums / Addon Language Packs / Chinese: How to change the max. length of category title in category menu?

Chinese: How to change the max. length of category title in category menu?

Locked

Started by ed7501 on 14 Aug 2009, 10:43 AM · Views: 2,622

Results 1 to 6 of 6
This thread is locked. New replies are disabled.
14 Aug 2009, 10:43 AM
#1
ed7501 avatar

ed7501

New Zenner

Join Date:
Jun 2009
Location:
Hong Kong
Posts:
12
Plugin Contributions:
0

Chinese: How to change the max. length of category title in category menu?

I have installed the Simplified Chinese language pack and have been slowly translating my site into Chinese. However, when I translate the category names, only a maximum of 4 characters is shown. For example, if I type in a category name that consists of 6 Chinese characters, only the first 4 will show.

How do I change the max. value so that the full name of the category in Chinese will be shown?

Any suggestions? Thanks,
Ed

19 Aug 2009, 4:41 AM
#2
shirster avatar

shirster

Zen Follower

Join Date:
Sep 2005
Location:
Hong Kong
Posts:
301
Plugin Contributions:
0

Re: Chinese: How to change the max. length of category title in category menu?

Could be the database field type restriction...

Using phpMyAdmin, go to your zen cart database, navigate to the "categories_descriptions" table, change the field type of "categories_name".

For example, if you have "varchar (32)", try and see if "varchar (64)" works for you.

Make sure you write this change down somewhere, so that you will remember this when you upgrade or reinstall zen cart months or years later.

Hope that helps :)

20 Aug 2009, 4:24 AM
#3
ed7501 avatar

ed7501

New Zenner

Join Date:
Jun 2009
Location:
Hong Kong
Posts:
12
Plugin Contributions:
0

Re: Chinese: How to change the max. length of category title in category menu?

shirster:

Could be the database field type restriction...

Using phpMyAdmin, go to your zen cart database, navigate to the "categories_descriptions" table, change the field type of "categories_name".

For example, if you have "varchar (32)", try and see if "varchar (64)" works for you.

Make sure you write this change down somewhere, so that you will remember this when you upgrade or reinstall zen cart months or years later.

Hope that helps :)

I tried what you advised, but unsuccessful. Are you using the Simplified Chinese language pack as well?

20 Aug 2009, 10:07 AM
#4
shirster avatar

shirster

Zen Follower

Join Date:
Sep 2005
Location:
Hong Kong
Posts:
301
Plugin Contributions:
0

Re: Chinese: How to change the max. length of category title in category menu?

Nope I'm using the Traditional Chinese language pack and do not have this problem. Sorry I can't be of much help !

21 Aug 2009, 9:47 AM
#5
ed7501 avatar

ed7501

New Zenner

Join Date:
Jun 2009
Location:
Hong Kong
Posts:
12
Plugin Contributions:
0

Re: Chinese: How to change the max. length of category title in category menu?

Actually, it did help. I had to retype the categories again in admin to see the results :)

Thanks!