On Monday 25 December 2000 19:12, Ben-Nes Michael wrote:
> Hi
>
> does any one know if postgresl (7) support hebrew charset ? (sorting,
> group ... )
> If so, what is the way to enable it ?
I haven't used Postgres 7, but unless they changed the internals very
seriously, it is supposed to support Hebrew, if you have the locale
installed on your machine (iw_IL locale, if I'm not mistaken). Note
that Postgres has to be compiled with --enable-locale.
Then, you have to set the proper environment variables to have locale
affect the operation of the client (or the server - if you want the
default to be Hebrew).
Not that there is much difference between using ISO-8859-1 or
ISO-8859-8 for this purpose, since unlike mySQL, all Postgres queries
are case-sensitive - so if you don't have Hebrew locale installed, you
can settle for 8859-1. Just take care not to use "C" - I think it's a
7-bit locale and won't like your Hebrew.
http://postgresql.readysetnet.com/devel-corner/docs/admin/charset.htm#LOCALE
Herouth
���������������������� unsubscribe, send mail to [EMAIL PROTECTED] with
the word "unsubscribe" in the message body, e.g., run the command
echo unsubscribe | mail [EMAIL PROTECTED]