By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,414 Members | 1,024 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,414 IT Pros & Developers. It's quick & easy.

How to pass initdb LC_COLLATE & locale parameters when using windows? (with or without pginstaller)

P: n/a
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 ma*******@postgresql.org)

Nov 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

for another locale

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

[postgres@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 ma*******@postgresql.org)


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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.