Re: how to make collation work

  This was help me, on Debian Sarge.
  PostgreSQL problems with collation sequence!
  #dpkg-reconfigure locales        - generate - "hu_HU" and NLS hu_UTF8
  #reboot
  #/etc/init.d/postgresql stop
  #su postgres -> postgres@srv02:

  empty directory /var/lib/postgres/data

  /usr/lib/postgresql/bin/initdb -U
postgres --locale=hu_HU --lc-collate=hu_HU -E LATIN2 \
 -D /var/lib/postgres/data -W --pwprompt
  ... set same password for "postgres" root

  cd /var/lib/postgres/data
  rm pg_hba.conf
  rm pg_ident.conf
  rm postgresql.conf

  ln -s /etc/postgresql/pg_hba.conf pg_hba.conf
  ln -s /etc/postgresql/pg_ident.conf pg_ident.conf
  ln -s /etc/postgresql/postgresql.conf postgresql.conf

  recreate users and databases - pg_dump?

----- Original Message -----
From: "Havasvölgyi Ottó" <h.otto@freemail.hu>
To: <pgsql-novice@postgresql.org>
Sent: Sunday, May 01, 2005 8:33 PM
Subject: [NOVICE] how to make collation work


> Hi all,
>
> I am a beginner in Linux and Postgres too, so take this into
> consideration.
> I have installed Fedora Core 3, and PostgreSQL 8.0.2 from source on it.
> All right so far. Now I would like to have a Hungarian collation in my
> tables. This is what I have tried so far:
> I checked what Hungarian locales my Linux supports. These are: hu_HU,
> hu_HU.iso88592, hu_HU.utf8, and hungarian. So far I have tried the first
> and the second with initdb, set the --locale, --lc-collate and --lc-ctype
> to that locale. But after filling a table with Hunagrian characters, and
> selecting it all with order by didn't give the result I expected. The
> encoding of the database and the client was both LATIN2. Neither worked
> the upper() and lower() functions correct with Hungarian characters.
>
> What did I do wrong? Please help.
>
> Thanks,
> Otto
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
>