servicevu Posted June 30, 2009 Share Posted June 30, 2009 Greetings, I have installed that Arabic language to my osC2.2 and the pages are displaying with no issue. But, when I add an arabic product name or description, it only shows the first few letters and cut the rest of the text. Is that something to do with the length of the field on mySQL or other some other issue? Regards, Aziz Link to comment Share on other sites More sharing options...
multimixer Posted June 30, 2009 Share Posted June 30, 2009 You need to go to the database, via phpmyadmin and increase the varchar of products_name (in table products_description) and of categories_name (table categories_description) to something higher than it is now My community profile | Template system for osCommerce - New: Responsive | Feedback channel Link to comment Share on other sites More sharing options...
♥ecartz Posted June 30, 2009 Share Posted June 30, 2009 I'm not sure that it is an issue in the database column length. Even the longest UTF-8 characters are only four bytes long and the name is sixty-four bytes in the default install (should support at least fifteen characters). The description is something like 16,384 bytes. If there is a problem in the description, it is almost certainly not a length issue. It still might be worth increasing the length of the field to 255 characters (the max for varchar), but I'm not sure that that is the issue here. I wonder if there is something about the Arabic characters that is keeping them from being displayed. Can you view the HTML source? Is the text correct in the source? Can you view the database (in phpMyAdmin or similar)? Is the text correct in the database? Is the database using a character encoding that is consistent with the Arabic characters? Always back up before making changes. Link to comment Share on other sites More sharing options...
multimixer Posted June 30, 2009 Share Posted June 30, 2009 I'm not sure that it is an issue in the database column length. I had this issue with greek and I solved it in that way. Don't ask me how and why, it just worked My community profile | Template system for osCommerce - New: Responsive | Feedback channel Link to comment Share on other sites More sharing options...
servicevu Posted July 4, 2009 Author Share Posted July 4, 2009 I had this issue with greek and I solved it in that way. Don't ask me how and why, it just worked I have increased it and it showing the proper text now. Nothing is being cut, but, when I view it in phpMyadmin, I can't read it. It only show those characters characters like # and & and numbers .. but it continues to display the right text on the user end :rolleyes: . The only issue, if I need to edit anything now, I need to change everything from the beginning as I do not know where is the text that I need to change in the editor. This would have a future issue if I want to search directly in the DB :blink: . Thank you for the advise. Abdulaziz Link to comment Share on other sites More sharing options...
multimixer Posted July 6, 2009 Share Posted July 6, 2009 I have increased it and it showing the proper text now. Nothing is being cut, but, when I view it in phpMyadmin, I can't read it. It only show those characters characters like # and & and numbers .. but it continues to display the right text on the user end :rolleyes: . The only issue, if I need to edit anything now, I need to change everything from the beginning as I do not know where is the text that I need to change in the editor. This would have a future issue if I want to search directly in the DB :blink: . Thank you for the advise. Abdulaziz Is the database set to utf-8? My community profile | Template system for osCommerce - New: Responsive | Feedback channel Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.