Questions tagged [locales]
The locales tag has no usage guidance.
14
questions
1
vote
2
answers
65
views
Why is the default collation not applied in PostgreSQL queries?
OS: Windows 10
Docker OS: Alpine Linux 3.18.3
DB: PostgreSQL 15
I created a new PostgreSQL database named test1 with zh-x-icu as the default collation using the following command:
postgres=> ...
- 111
1
vote
1
answer
62
views
pg_trgm not working on non-Latin and macOS
Trigrams don't work for non-Latin languages on the Mac.
On the Mac, I'm getting the following behavior:
select show_trgm('peace') -> {" p"," pe",ace,"ce ",eac,pea}
...
- 111
3
votes
2
answers
2k
views
How can I get a list of locales in PostgreSQL?
I want to change number and currency format using something like:
SET lc_numeric='en_AU.UTF-8'
SET lc_money='en_AU.UTF-8'
I tried a number of formats for, say, Dutch, but nothing works. It appears ...
- 2,759
0
votes
1
answer
225
views
'lc_time_names' can't be set to the value of 'de_DE'
Works:
SET lc_time_names='en_US';
Fails with "Variable 'lc_time_names' can't be set to the value of 'de_DE'":
SET lc_time_names='de_DE';
This seemed simple to me. I guess, I have to ...
- 105
2
votes
1
answer
430
views
postgres: do I really need to use Collate and Ctype when restoring database?
Need to import in Linux a Windows postgres exported database.
In windows it's listed as follows:
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----...
- 123
2
votes
0
answers
182
views
Problem with decimal point setting in Windows
I am using bcp.exe from a SQL Server 2017 installation on Windows 10 (build 19041). The OS language is English (US) but I use scandinavian settings for date, time, currency and decimal delimiter - the ...
3
votes
1
answer
487
views
Specific changes to glibc 2.28 that affect PostgreSQL
I am preparing for upgrading a PostgreSQL server to Debian 10 (Buster) with the warning from Debian release notes about changes to gclibc affecting PostgreSQL in mind. The PostgreSQL wiki provides two ...
- 348
1
vote
0
answers
392
views
Difference between LC_COLLATE='C' and LC_COLLATE='C.UTF-8' in PostgreSQL [duplicate]
I need guidance on the exact distinction, if any, between LC_COLLATE='C' and LC_COLLATE='C.UTF-8' in PostgreSQL. It seems to me that they behave exactly the same and that the codeset (with bearing on ...
- 348
0
votes
1
answer
513
views
Default value format of a stored procedure parameter(of datatype : money)
With my query:
SELECT (CAST(0.00 AS MONEY))
I am expecting a result : 0.00
But it shows me the result: 0,00(with comma)
I checked this query ,when i found that,the CREATE PROCEDURE script ...
- 11
1
vote
1
answer
846
views
Change locale of Postgres server
I have a big Postgres server with 2 Tb of data that has been created with the wrong locale.
How can I correct it, without recreating the whole server with pg_dump and pg_restore. It would take a ...
- 265
0
votes
1
answer
329
views
How to know the locale that has been used to initialize a Postgres server?
I need it in order to create a new database with initdb with the same locale, otherwise pg_upgrade will fail.
- 265
2
votes
5
answers
6k
views
Locale is incompatible error in Postgresql 10 when replicating from Ubunu to Win 10
The locale available in my Ubuntu PG-10 DB is en_US.UTF-8. When doing PG_Basebackup to a PG-10 DB in Win-10, Psql failed to connect with error
psql: FATAL: database locale is incompatible with ...
- 21
19
votes
3
answers
25k
views
PostgreSQL: difference between collations 'C' and 'C.UTF-8'
In PostgreSQL, what is the difference between collations C and C.UTF-8?
Both show up in rows of pg_collation. Is it perhaps the case that C.UTF-8 is the same as C with encoding UTF-8 regardless or ...
- 348
2
votes
1
answer
2k
views
Storage and presentation of database data across multiple languages
Apologies if this has been asked before. After extensive searching I cannot find anything that serves as a solution (a similar answer is posted below). I am afraid this is an open-ended (broad) ...
- 840