Re: Please HELP Romanian charset Collate in MySQL
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)) > > ÎteIbur > > Ibur Îte > > ItoIto > > > > 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]
Re: Please HELP Romanian charset Collate in MySQL
I can copy the latin2.conf into new one, but I need to know what each codefrom the conf file represents and how can I obtain the relation from thesecodes and the chars.So that's two problems:1) Can I use asc function or what function I need to know to obtain thecodes from the chars?2) How is the way to arrange the codes in the conf file? Assuming that Iknow the codes for each characters (found at the above point) how can I putthese 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 PMSubject: 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] smime.p7s Description: S/MIME cryptographic signature
Re: Please HELP Romanian charset Collate in MySQL
Hi! On Jul 28, Primaria Falticeni wrote: > Hello, > > Simply I made a table with romanian characters "aAsStT". I tried to > sort it, in fact to order it in a query. > > 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. check http://www.mysql.com/doc/en/Localisation.html Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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)) ÎteIbur Ibur Îte ItoIto 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]
