slekkas Posted June 25, 2011 Share Posted June 25, 2011 In my store in the greek section if you go to http://vithosclub.gr/test.php?language=gr you will see that the category names stop at 16 characters and at the end i get this strange symbol "�". I get something like this: "Επαγγελματικο Ψα�" instead of "Επαγγελματικο Ψαρεμα". In English i don't have this problem. If the name is too long it will go under one line. Any tips? Searched around but i didn't find anything helpful. Link to comment Share on other sites More sharing options...
multimixer Posted June 25, 2011 Share Posted June 25, 2011 Go to your phpMyAdmin, find the database, table categories_description, field categories_name and change the varchar value from 128 to something higher, like 256. This should fix it My community profile | Template system for osCommerce - New: Responsive | Feedback channel Link to comment Share on other sites More sharing options...
♥kymation Posted June 25, 2011 Share Posted June 25, 2011 Varchar is limited to 255 characters max. If you need more, change the field type to text. Regards Jim See my profile for a list of my addons and ways to get support. Link to comment Share on other sites More sharing options...
multimixer Posted June 25, 2011 Share Posted June 25, 2011 Varchar is limited to 255 characters max. If you need more, change the field type to text. Regards Jim ups, yes :) My community profile | Template system for osCommerce - New: Responsive | Feedback channel Link to comment Share on other sites More sharing options...
slekkas Posted June 25, 2011 Author Share Posted June 25, 2011 Go to your phpMyAdmin, find the database, table categories_description, field categories_name and change the varchar value from 128 to something higher, like 256. This should fix it I did this but i still have this problem :( Link to comment Share on other sites More sharing options...
multimixer Posted June 25, 2011 Share Posted June 25, 2011 Can you also add back the original categories box? Maybe your box is doing something here My community profile | Template system for osCommerce - New: Responsive | Feedback channel Link to comment Share on other sites More sharing options...
slekkas Posted June 25, 2011 Author Share Posted June 25, 2011 Can you also add back the original categories box? Maybe your box is doing something here It did the same before as well. I just changed it a few minutes ago. I don't think this is the problem. Link to comment Share on other sites More sharing options...
EliteViper Posted June 25, 2011 Share Posted June 25, 2011 Make sure you go back into the product and edit the category name again because after you did it the first time it "cut" it to 16 chars, now it needs to have the full name reinserted into the DB before it will show full. Link to comment Share on other sites More sharing options...
slekkas Posted June 25, 2011 Author Share Posted June 25, 2011 Make sure you go back into the product and edit the category name again because after you did it the first time it "cut" it to 16 chars, now it needs to have the full name reinserted into the DB before it will show full. Thanks for your help Link to comment Share on other sites More sharing options...
EliteViper Posted June 25, 2011 Share Posted June 25, 2011 Thanks for your help NP, I hope that solved your problem. :) Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.