Iulian, this is in the manual. Look at Database Administration Localisation Character arrays
Regards, Thomas Spahni On Wed, 30 Jul 2003, Primaria Falticeni wrote: > I can copy the latin2.conf into new one, but I need to know what each code > from the conf file represents and how can I obtain the relation from these > codes and the chars.So that's two problems: > 1) Can I use asc function or what function I need to know to obtain the > codes from the chars? > 2) How is the way to arrange the codes in the conf file? Assuming that I > know the codes for each characters (found at the above point) how can I put > these codes in the three tables within the latin2.conf file? > > ----- Original Message ----- > From: "Primaria Falticeni" <[EMAIL PROTECTED]> > To: "MySQL LIST" <[EMAIL PROTECTED]> > Sent: Monday, July 28, 2003 10:00 PM > Subject: Please HELP Romanian charset Collate in MySQL > > > > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]