Re: How to pass initdb LC_COLLATE & locale parameters when using wind ows? (with or without pginstaller)

for another locale

be sure to use a corret locale or it won't work

[postgres(at)www pgsql]$ initdb --locale=ko_KR.UTF8 --lc-messages=C -E unicode -D `pwd`/unidata

On Fri, Sep 24, 2004 at 02:04:23PM +0200, Manolatos Tilemahos wrote:
> Dear friends,
>
> First pls accept my apologies, because I am a new Postgres user, so my
> questions could be silly.
>
> We need to setup a database using UTF-8 encoding, however, by some way, we
> have to express our need for right Greek character collation order.
> I tried the default installation using pginstaller, then I created a db
> (using pgAdminIII) using UTF-8, but still the collation is wrong (=wrong
> upper() and "order by") for Greek characters.
>
> After some googling, I guess that I need to call initdb with the proper
> locale.
>
> Could you please help me with the below questions?
> 1. Is there a way to define locale options to the pginstaller?
> 2. If not, how can I (at least) create a new database with UTF-8 and el_GR
> locale?
>
> I am currently using Postgres 8.0 beta1 on Windows XP Pro, and having Greek
> locale to my computer.
>
> Thank you very much in advance, we really appreciate Postgres' superior
> performance and features.
>
> Greetings from Greece,
> Tilemahos
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

--
if you're christian, god bless; otherwise, good luck; and, if you dont believe in luck ...