pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCreating a database with LC_COLLATE tr_TR.UTF-8
5+ messages / 4 participants
[nested] [flat]
* Creating a database with LC_COLLATE tr_TR.UTF-8
@ 2016-12-30 14:25 Ertan Küçükoðlu <ertan.kucukoglu@1nar.com.tr>
0 siblings, 2 replies; 5+ messages in thread
From: Ertan Küçükoðlu @ 2016-12-30 14:25 UTC (permalink / raw)
To: pgsql-admin
Hello,
I am quite new to the community and PostgreSQL. My search in the acrhieves
did not show any hints.
I just installed PostgreSQL 9.6.1 64bit on Windows 10 64bit OS. Used
EnterpriseDB setup.
I wanted to create a database using LC_COLLATE "tr_TR.UTF-8". My pgsql
command and error I receive is as follows:
postgres=# CREATE DATABASE collationtest ENCODING 'UTF-8' LC_COLLATE
'tr_TR.UTF-8' TEMPLATE template0;
ERROR: invalid locale name: "tr_TR.UTF-8"
postgres=#
Just for a test, I tried 'tr_TR.UTF8', 'tr_TR' and got same result for all.
I am open to any advises and appreciate any help.
Thanks & regards,
Ertan Küçükoðlu
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Creating a database with LC_COLLATE tr_TR.UTF-8
@ 2016-12-30 14:52 Tom Lane <tgl@sss.pgh.pa.us>
parent: Ertan Küçükoðlu <ertan.kucukoglu@1nar.com.tr>
1 sibling, 1 reply; 5+ messages in thread
From: Tom Lane @ 2016-12-30 14:52 UTC (permalink / raw)
To: Ertan Küçükoðlu <ertan.kucukoglu@1nar.com.tr>; +Cc: pgsql-admin
=?iso-8859-9?B?RXJ0YW4gS/zn/Gtv8Gx1?= <ertan.kucukoglu@1nar.com.tr> writes:
> I just installed PostgreSQL 9.6.1 64bit on Windows 10 64bit OS.
On Windows you'd have to use Windows' locale names. My first guess
would've been that those are completely unlike anybody else's, but
some googling suggests that "tr-TR" (dash not underscore) will work:
https://msdn.microsoft.com/en-us/library/windows/desktop/dd373814(v=vs.85).aspx
But the easy answer is to look into the pg_collation system catalog
and see what names are installed.
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Creating a database with LC_COLLATE tr_TR.UTF-8
@ 2016-12-30 15:00 Samed YILDIRIM <samed@reddoc.net>
parent: Ertan Küçükoðlu <ertan.kucukoglu@1nar.com.tr>
1 sibling, 1 reply; 5+ messages in thread
From: Samed YILDIRIM @ 2016-12-30 15:00 UTC (permalink / raw)
To: Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>; pgsql-admin
<div>Hi Ertan,</div><div> </div><div>Locale names are different on Windows and Linux. Please try using following command to create new database.</div><div>CREATE DATABASE collationtest ENCODING 'UTF8' LC_COLLATE 'Turkish_Turkey.1254' LC_CTYPE = 'Turkish_Turkey.1254' TEMPLATE template0;</div><div> </div><div>Note on document:</div><div>On Windows, however, UTF-8 encoding can be used with any locale.</div><div><em>Ref:</em> <a href="https://www.postgresql.org/docs/9.6/static/multibyte.html">https://www.postgresql.org/docs/9.... regards.</div><div>Samed YILDIRIM</div><div> </div><div>30.12.2016, 16:26, "Ertan Küçükoğlu" <ertan.kucukoglu@1nar.com.tr>:</div><blockquote type="cite"><p>Hello,<br /><br />I am quite new to the community and PostgreSQL. My search in the acrhieves<br />did not show any hints.<br /><br />I just installed PostgreSQL 9.6.1 64bit on Windows 10 64bit OS. Used<br />EnterpriseDB setup.<br /><br />I wanted to create a database using LC_COLLATE "tr_TR.UTF-8". My pgsql<br />command and error I receive is as follows:<br /><br />postgres=# CREATE DATABASE collationtest ENCODING 'UTF-8' LC_COLLATE<br />'tr_TR.UTF-8' TEMPLATE template0;<br />ERROR: invalid locale name: "tr_TR.UTF-8"<br />postgres=#<br /><br />Just for a test, I tried 'tr_TR.UTF8', 'tr_TR' and got same result for all.<br />I am open to any advises and appreciate any help.<br /><br />Thanks & regards,<br />Ertan Küçükoğlu<br /><br /><br /><br /><br /><br /><br /> </p><span>--<br />Sent via pgsql-admin mailing list (<a href="mailto:pgsql-admin@postgresql.org">pgsql-admin@postgresql.org</a>)<br />To make changes to your subscription:<br /><a href="http://www.postgresql.org/mailpref/pgsql-admin">http://www.postgresql.org/mailpref/pgsql-admi...;
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Creating a database with LC_COLLATE tr_TR.UTF-8
@ 2016-12-30 15:06 Ertan Küçükoðlu <ertan.kucukoglu@1nar.com.tr>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 5+ messages in thread
From: Ertan Küçükoðlu @ 2016-12-30 15:06 UTC (permalink / raw)
To: 'Tom Lane' <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
Dear Tom,
Your suggestion worked just fine. Thanks.
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Tom Lane
Sent: Friday, December 30, 2016 5:53 PM
To: Ertan Küçükoðlu <ertan.kucukoglu@1nar.com.tr>
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Creating a database with LC_COLLATE tr_TR.UTF-8
=?iso-8859-9?B?RXJ0YW4gS/zn/Gtv8Gx1?= <ertan.kucukoglu@1nar.com.tr> writes:
> I just installed PostgreSQL 9.6.1 64bit on Windows 10 64bit OS.
On Windows you'd have to use Windows' locale names. My first guess would've
been that those are completely unlike anybody else's, but some googling
suggests that "tr-TR" (dash not underscore) will work:
https://msdn.microsoft.com/en-us/library/windows/desktop/dd373814(v=vs.85).a
spx
But the easy answer is to look into the pg_collation system catalog and see
what names are installed.
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Creating a database with LC_COLLATE tr_TR.UTF-8
@ 2016-12-30 15:13 Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>
parent: Samed YILDIRIM <samed@reddoc.net>
0 siblings, 0 replies; 5+ messages in thread
From: Ertan Küçükoğlu @ 2016-12-30 15:13 UTC (permalink / raw)
To: 'Samed YILDIRIM' <samed@reddoc.net>; pgsql-admin
Hello Samed,
After testing, I see that your sugestion also works.
Thank you.
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Samed YILDIRIM
Sent: Friday, December 30, 2016 6:01 PM
To: Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Creating a database with LC_COLLATE tr_TR.UTF-8
Hi Ertan,
Locale names are different on Windows and Linux. Please try using following command to create new database.
CREATE DATABASE collationtest ENCODING 'UTF8' LC_COLLATE 'Turkish_Turkey.1254' LC_CTYPE = 'Turkish_Turkey.1254' TEMPLATE template0;
Note on document:
On Windows, however, UTF-8 encoding can be used with any locale.
Ref: https://www.postgresql.org/docs/9.6/static/multibyte.html
Best regards.
Samed YILDIRIM
30.12.2016, 16:26, "Ertan Küçükoğlu" <mailto:ertan.kucukoglu@1nar.com.tr>:
Hello,
I am quite new to the community and PostgreSQL. My search in the acrhieves
did not show any hints.
I just installed PostgreSQL 9.6.1 64bit on Windows 10 64bit OS. Used
EnterpriseDB setup.
I wanted to create a database using LC_COLLATE "tr_TR.UTF-8". My pgsql
command and error I receive is as follows:
postgres=# CREATE DATABASE collationtest ENCODING 'UTF-8' LC_COLLATE
'tr_TR.UTF-8' TEMPLATE template0;
ERROR: invalid locale name: "tr_TR.UTF-8"
postgres=#
Just for a test, I tried 'tr_TR.UTF8', 'tr_TR' and got same result for all.
I am open to any advises and appreciate any help.
Thanks & regards,
Ertan Küçükoğlu
--
Sent via pgsql-admin mailing list (mailto:pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2016-12-30 15:13 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-12-30 14:25 Creating a database with LC_COLLATE tr_TR.UTF-8 Ertan Küçükoðlu <ertan.kucukoglu@1nar.com.tr>
2016-12-30 14:52 ` Tom Lane <tgl@sss.pgh.pa.us>
2016-12-30 15:06 ` Ertan Küçükoðlu <ertan.kucukoglu@1nar.com.tr>
2016-12-30 15:00 ` Samed YILDIRIM <samed@reddoc.net>
2016-12-30 15:13 ` Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox