Thank you for a kind reply,
Seems my question about 'BEST' way was written unclear. Sorry for that.
I was thinking is there any way to do this without recompiling with
different charset. I was looking for solution something like
'SortArbBiLex' PERL module to work with different charsets on the fly,
as in fact I need to deal with few languages in different tables of
mySQL.
Maybe I just use that PERL module...
thanks for all the support and patience reading my bad English.
Kazys
webmaster
http://www.junet.net
Alistair MacDonald wrote:
>
> On Sun, 17 Jan 1999, webmaster Junet wrote:
>
> > Hi all,
> >
> > I use mySQL and PERL DBI.
> > I need to sort returned data using non English charset. Something like
> > 'A','A','B','C','C'
> > (ANSI 65,192,66,67,200...)
> > what is the best way to do that?
>
> Sort order is a compile-time setting. From the manual (Section 4.7.3:
> Typical configure options, referenced from Section 9.1.1: The character
> set used for data and sorting )
>
> By default, MySQL uses the ISO-8859-1 (Latin1) character set. To change
> the default set, use the --with-charset option:
>
> shell> ./configure --with-charset=CHARSET
>
> CHARSET may be one of big5, czech, danish, dec8, dos, german1,
> hebrew, hp8, hungarian, koi8_ru, ru, latin1, latin2, sjis, swe7, tis620,
> ujis, usa7 or win1251. See section 9.1.1 The character set used for data
> and sorting. Note that if you want to change the character set, you must
> do a make distclean between configurations ! If you want to convert
> characters between the server and the client, you should take a look at
> the SET OPTION CHARACTER SET command. See section 7.24 SET OPTION syntax.
> Warning: If you change character sets after having created any tables, you
> will have to run isamchk -r -q on every table. Your indexes may be sorted
> incorrectly otherwise. (This can happen if you install MySQL, create some
> tables, the reconfigure MySQL using a different character set and
> reinstall it.)
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
