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.
