djp1988 Posted February 28, 2009 Share Posted February 28, 2009 I ahve a list of countries with their local names and austria is Österreich, the problem is it appears last in the result after an ORDER BY localname ASCHow can I make it so it treats the Ö of Österreich as a usual 'O' so it appears correctly in the list? Link to comment Share on other sites More sharing options...
Technage Posted March 2, 2009 Share Posted March 2, 2009 I think this is a collation issue, you might have to use a more robust collation method. If this is sql server you might find the answer here http://blogs.msdn.com/michkap/ all this guy deals with is such issues. Otherwise I am not sure if you only have the Roman alphabet to worry about you could probably find a collation to solve every letter. Link to comment Share on other sites More sharing options...
djp1988 Posted March 2, 2009 Author Share Posted March 2, 2009 Thanks, yes I was in latin something for that field so I changed it to utf 8 unicode and it now orders that character in the correct place Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.