Forums / Addon Language Packs / category longer than 16 characters �

category longer than 16 characters �

Started by satyros on 12 Jan 2012, 1:27 PM · Views: 1,988

Results 1 to 3 of 3
12 Jan 2012, 1:27 PM
#1
satyros avatar

satyros

New Zenner

Join Date:
Dec 2011
Location:
Athens, Greece
Posts:
33
Plugin Contributions:
0

category longer than 16 characters �

Hi there, I've succesfully installed Greek language but I just noticed than if one categorie is longer than 16 characters a � symbol appears. It is not happening if I use English characters. All my language files are UTF8 encoded.
any clues?

http://www.koufetakia.gr/eshop/index.php?main_page=

17 Jan 2012, 2:08 PM
#2
athens_collectibles avatar

athens_collectibles

Zen Follower

Join Date:
May 2010
Location:
Athens, Greece
Posts:
293
Plugin Contributions:
0

Re: category longer than 16 characters �

I had the same issue with Greek characters. Apparently, each character takes two or more bytes in the database and the product name field is not long enough. Here is the solution I experimented with and it worked:

Go to your database, find the table products_description and click on it. When it opens on the right side, click the Structure button on top. The third field in the new screen is called products_name. Click on the pencil icon in the same line to edit it. Find the Length/Values field and change the value in the box from whatever it is to something around 100 or more, depending on the length of the product names you use. I have set mine to 130 but I would increase it in the future if necessary. Finally, click the Save button and you are ready.

If you have already names truncated with the funny symbol next to them, you will have to re-enter them.

I hope that it will work for you. After all, we are both talking Greek.

Καλό απόγευμα.

17 Jan 2012, 4:10 PM
#3
athens_collectibles avatar

athens_collectibles

Zen Follower

Join Date:
May 2010
Location:
Athens, Greece
Posts:
293
Plugin Contributions:
0

Re: category longer than 16 characters �

Apologies Satyros, that was the "difficult" way to do it. just discovered that you can also increase the number of characters from Configuration > Product Listing > Display Product Description.