imap Posted February 22, 2007 Share Posted February 22, 2007 hello all, when I put a category name in Unicode, it's trimmed to 4 symbols.. Anything can be done? example: www.look.ge (it's in English by default, but when you click on the flag..) Wonder what affects it's trimming.. Is that database issue? kind regards Link to comment Share on other sites More sharing options...
Guest Posted February 22, 2007 Share Posted February 22, 2007 The length of the category name is set in the Data Base. It only accepts a certain number of characters and then cuts off. Using PHPMyAdmin you can change the length allowed but will probably have to enter the categories again or fix them individually in the DB. This is only if they are all being cut off after XX number of characters. Link to comment Share on other sites More sharing options...
Velveeta Posted February 22, 2007 Share Posted February 22, 2007 The length of the category name is set in the Data Base. It only accepts a certain number of characters and then cuts off. Using PHPMyAdmin you can change the length allowed but will probably have to enter the categories again or fix them individually in the DB. This is only if they are all being cut off after XX number of characters. Yeah I answered a question like this a while back, his names were being cut after 4 characters as well... It boiled down to either the database was storing those multibyte characters in utf-8 format, where 1 foreign character might be something like ^M017^BA or something, or it may have been inserted html entities into the string, such as the a with the acute accent mark looking like this: Á... which takes up 8 spaces by itself for 1 character... Listen to Java Roasters, just extend the length of that field in the database, and it should clear this issue up... I just thought I'd provide an explanation for why it's doing that :D Richard. Richard Lindsey Link to comment Share on other sites More sharing options...
imap Posted February 23, 2007 Author Share Posted February 23, 2007 Yeah I answered a question like this a while back, his names were being cut after 4 characters as well... It boiled down to either the database was storing those multibyte characters in utf-8 format, where 1 foreign character might be something like ^M017^BA or something, or it may have been inserted html entities into the string, such as the a with the acute accent mark looking like this: Á... which takes up 8 spaces by itself for 1 character... Listen to Java Roasters, just extend the length of that field in the database, and it should clear this issue up... I just thought I'd provide an explanation for why it's doing that :D Richard. Thanks a lot :) case closed. 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.