Iulian, take the source code, go to 'sql/share/charsets' and create your own character set 'romanian.conf' departing from 'latin2.conf' (or whatever is closest to what you need).
Regards, Thomas Spahni On Mon, 28 Jul 2003, Primaria Falticeni wrote: > 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(iso-8859-2 I think) the same like > win1250(central european)) > Ste Sbur > Sbur Ste > Sto Sto > > The correct result must be: Sbur, Sto, Ste 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 > Economis/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]