RE: Problem with character set

I don't really know.... I think there's no way to sort it alphabetically in other languages then English since it is different thing to have a character support and languages support, even if Italian and Spanish are using Latin characters the alphabet is different, so I don't think MySQL support it. What you could do instead is to use C or PHP or any other language that could do it for you, it is pretty easy to set an order and then to loop out the data from the database sorted in that way... Sprosi svoih kolleg/druzey ob etom kto znaet MySQL, oni dolzhny eto znat ... :-)) -----Original Message----- From: Ovchinnikov Alexey [mailto:alexiss@svl.ru] Sent: Thursday, September 07, 2000 3:11 PM To: Maxim Maletsky Subject: Re: Problem with character set Hi Maxim ! My data stored OK too. But result of 'ORDER BY' not looks like alphabetical order. Numbers sorted OK, but not strings :-( What do you thing about it ? ----- Original Message ----- From: Maxim Maletsky <maxim.maletsky@lincmedia.co.jp> To: 'Ovchinnikov Alexey' <alexiss@svl.ru> Cc: <mysql@lists.mysql.com> Sent: Wednesday, September 06, 2000 3:56 PM Subject: RE: Problem with character set > I always thought that all the character sets are OK in mySQL, > somehow I can store Japanese .... > > Udachi! > > -----Original Message----- > From: Ovchinnikov Alexey [mailto:alexiss@svl.ru] > Sent: Wednesday, September 06, 2000 8:54 PM > To: MySQL mailing list > Subject: Problem with character set > > > My name is Alexey, I work in Moscow company SOLVALUB. > I have following problem. > My data stored in russian WIN-1251 charset, but in MySQL its defaults to ISO > Documentation reference to start MySQL deamon with key > --character-set=[file] > but I can't find file, containts WIN-1251 encoding. > > Could you help me please? > > Thanks > Alexey > > -- > --------------------------------------------------------------------- > Please check "http://www.mysql.com/php/manual.php" > before > posting. To request this thread, e-mail mysql-thread49827@lists.mysql.com > > To unsubscribe, send a message to: > <mysql-unsubscribe-alexiss=svl.ru@lists.mysql.com> > > If you have a broken mail client that cannot send a message to the above address(Microsoft Outlook), you can use http://lists.mysql.com/php/unsubscribe.php >