Re: proper ordering of a UNICODE / Hebrew postgres database cluster

> This is probably a pretty stupid thing we are missing but we cant get hebrew to collate properly in PG7.1
>
> We are running PG7.1 on RH6.2 with ACS 3.2/AOLServer
>
> we set LC_COLLATE and LC_CTYPE to iw_IL.UTF-8 as the system locale. (We want to support hebrew)
>
> we then ran INITDB, createdb -E UNICODE and started entering data.
>
> However - the hebrew data collates randomly on a SELECT ....ORDER by....
> statement. FWIW - it seems to collate strings of a single character properly
>
> Is this a bug in PG7.1?
> what do we need to do to setup the db cluster properly so that the ORDER will collate the unicode words properly?

Have you enabled the locale support (--enable-locale)? If you enable
it, and still see the problem, then there might be problems with the
locale database. Can you run a small program something like following?

#include <string.h>
#include <locale.h>
main()
{
static char *s1 = "utf_8_hebrew_string_here";
static char *s2 = "another_utf_8_hebrew_string_here";";

setlocale(LC_ALL,"");

printf("%d\n",strcoll(s2,s1));
}