Hytham, Thursday, July 25, 2002, 12:54:22 AM, you wrote: HS> am running mysql 3.44 at RHL7.2, how can i setup up mysql to store/show HS> characters of language such as hebrew/arabic?
MySQL returns char strings as they were inserted. For correct sorting you can set up hebrew character set starting mysqld with --default-character-set=hebrew MySQL doesn't have arabic character set. As a quick solution for correcting sorting is storage your data as binary in BLOB or VARCHAR BINARY columns. You can also add arabic support by yourself. How to do so read in the MySQL manual, section '4.6.3 Adding a New Character Set': http://www.mysql.com/doc/A/d/Adding_character_set.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php