Questions tagged [locales]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
0answers
25 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 ...
0
votes
1answer
66 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 ...
0
votes
0answers
93 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 ...
0
votes
1answer
12 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.
1
vote
2answers
417 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 ...
1
vote
3answers
1k 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 ...
2
votes
1answer
150 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) ...