If this is your first visit, check our documentation. To post, register or login.
Forums / Addon Language Packs / Category/Product Names Get Shortened...

Category/Product Names Get Shortened...

Locked

Started by peace_freak on 4 Aug 2006, 12:08 AM · Views: 3,844

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
4 Aug 2006, 12:08 AM
#1
peace_freak avatar

peace_freak

Zen Follower

Join Date:
Apr 2006
Posts:
354
Plugin Contributions:
0

Category/Product Names Get Shortened...

I originally posted this in First Steps & General Customization Issues section but had not had any response so I re-posting here...

I am in the process of localizing my store to Japanese. When writing product category names or even the product names themselves in Japanese, for some reason, they get cut off. They are not particularly long names...

In the product preview window they appear as full length names, but once I press the update button, the name shortens.

For example, this category : ???????

gets cut off and ends up shortened to this : ????

(I have run various tests and in the preview window, even if the Japanese name is shorter in length than the English name, the same problem occurs)

I thought this might be a setting problem but as I have now found it applies to both categories AND product names I doubt it....

I think it might have something to do with 2 bit characters...

I look forward to any suggestions or solutions as soon as possible...

4 Aug 2006, 1:20 AM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Category/Product Names Get Shortened...

I just did a search on "product name length" and got this:
http://www.zen-cart.com/forum/showthread.php?t=41634&highlight=product+length

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

4 Aug 2006, 9:30 AM
#3
peace_freak avatar

peace_freak

Zen Follower

Join Date:
Apr 2006
Posts:
354
Plugin Contributions:
0

Re: Category/Product Names Get Shortened...

Hello Dr. Byte!

Thank you for your reply! Here is a step by step explanation of what I did to solve the problem.

I went to phpMyAdmin. As I have a problem with Categories I chose zen_categories_description. Within there, in the Categories Name section the length was set to 32. I increased it to 64.

For Product Names, I found zen_products_description.... From within that I edited products_name from 64 say 150. I was surprised I had to go up so high but I did it incrementally and only there I could get everything to show up...

Now, Ajeh said the following: NOTE: Be sure you changed the length of the products_name in all tables ... or you will have some pretty short orders

So I need to go through everywhere that has products_name and change the length to 150...

I went through everything and here are what I found:

zen_customers_wishlist
zen_orders_products

So I should change these to 150 as well?

Should I write a suggestion in the Bug Reports or Code Suggestions forum sections to increase the length for Category/Product names? As the Zen-Cart is pretty international, I think it would be a good idea and will save Japanese and perhaps other users using 2 bit characters quite a bit of time and hassle...

Once again, thanks for your excellent help!

4 Aug 2006, 10:14 AM
#4
peace_freak avatar

peace_freak

Zen Follower

Join Date:
Apr 2006
Posts:
354
Plugin Contributions:
0

Re: Category/Product Names Get Shortened...

I want to add that I have had to increase the products_name to 200. I found some other products in my store that needed still more length!

21 Aug 2006, 5:21 AM
#5
peace_freak avatar

peace_freak

Zen Follower

Join Date:
Apr 2006
Posts:
354
Plugin Contributions:
0

Re: Category/Product Names Get Shortened...

Further update...

Had to make further adjustments on this and came up with a name length of 255.

For anyone who is not sure how to change the length, go to phpMyAdmin for your Zen_Cart and choose the appropriate database. In the left hand column, double click on, for example, zen_categories_description.

In the window that comes up, click on the ‘pencil’ icon in the row with categories_name. This allows you to change or edit the item. In the next window that comes up change the Length/Values column number to the length you want and click save.