PDA

View Full Version : alphabetical order error non english charset


torter
06-19-2007, 11:17 AM
i am using alphabetical order in my categories.
but when site title is beginning with Ö , the link is listed at the end of category.

how can i solve thsi problem. i am using version 2.1

falsealarm
06-20-2007, 04:09 PM
Thanks in advance to whomever can shed some light on this issue. When using Turkish characters, with the category entries, TITLE column gets modified and the alphabetical order gets screwed up as the special Turkish special characters are replaced with '_' underscores.
Various resources indicate that the database character set needs to be 'latin5_turkish_ci' however there is still an issue after this change is made. It is also indicated that

mysql_query (http://www.php.net/mysql_query)("SET NAMES 'latin5'");

needs to be added to the php code. Does this make sense? Where would this go in the code?