Hello, Simply I made a table with romanian characters "aAîÎâÂsStT". I tried to sort it, in fact to order it in a query.
I settled the default_charset to some charsets: latin1(default) (latin2 win1250(central european)) Îte Ibur Ibur Îte Ito Ito The correct result must be: Ibur, Ito, Îte in ascending order. How can I do this? Please give me an example at how can I change the latin2.conf in a romanian one to fairly sort the chars for me. I must do change the behaviour and I don't know how. Thanks Anticipated, Iulian Teodosiu Economist/Analyst Programmer Primaria Falticeni Falticeni (town), jud. Suceava Romania, Europe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]