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

Reply via email to