Questions tagged [localization]

Use localization tag for issues related to formatting and storage of data affected by locale (language and country), such as language character sets, decimal number separators, and date formatting.

Filter by
Sorted by
Tagged with
0
votes
1answer
33 views

Schema and Query design for table with multiple languages [closed]

I've been researching on how to create a schema for a database that contains multiple languages. So I decided to separate the translations on a different table with a column as the language and ...
1
vote
1answer
481 views

Recreate fixed views

Is it possible to recreate Oracle fixed views? I have a performance problem with GV$ACTIVE_SESSION_HISTORY that might require rebuilding the view. A simple select * from gv$active_session_history; ...
1
vote
0answers
268 views

Why the decimal marker I get is not the one defined in NLS_NUMERIC_CHARACTERS?

According to the Oracle documentation, NLS_NUMERIC_CHARACTERS stores the decimal marker used by the current session. To get the current NLS_NUMERIC_CHARACTERS, I use this request: select value from ...
2
votes
1answer
109 views

International Components for Unicode (ICU) Date Formatter for MySQL?

Regarding to ICU - International Components for Unicode definition: ICU is a mature, widely used set of C/C++ and Java libraries providing Unicode and Globalization support for software ...
5
votes
1answer
1k views

Postgres - Encoding, Collation and CType

List of databases Name | Owner | Encoding | Collate | Ctype | -------------------------+----------+----------+---------------------------...
1
vote
1answer
154 views

What is the purpose of the “territory” configuration parameter?

This is the command that I use to create a new Db2 database in my project: db2 create db <DATABASE_NAME> using codeset 1251 territory ru Unfortunately, there is no documentation left and I ...
2
votes
2answers
168 views

Internationalization of a Supertype-subtype

First of all, my apologies for tieing this question with another one, but that was the best way I could think to keep it simple and focused Months ago I was introduced to the supertype-subtype as ...
3
votes
1answer
594 views

Setting locale for Chinese characters in Postgresql

I am designing a Postgresql database that contains Chinese characters in certain tables (.e.g login, comments). Most tables are perfectly fine with ASCII characters. From Postgresql Locale Support, ...
1
vote
2answers
5k views

Special characters in Oracle utl_http request

When calling a web service using utl_http, the calls fail when the SOAP envelope contains characters like ¿, ± or º. IS http_req utl_http.req; http_resp utl_http.resp; request_env ...
1
vote
1answer
616 views

Trying to create a collation on Postgres 9.6; a nonsensical error message

I'm running Postgres 9.6.1 on a Debian-based Docker image. My default locale is en_US.utf8. I'm trying to create a collation of type ja_JP.utf8. I have the Japanese locale installed as demonstrated by ...
2
votes
1answer
218 views

Cross-cutting I18N native support in databases

Does a database engine with native cross-cutting internationalization support exist, able to store data like this? SET LOCALE='en' SELECT * FROM BOOKS +------+-----------------------+----------------...
2
votes
1answer
260 views

Adding custom language to SQL Server

I would like to use SQL Server @@langid variable to return different data based on current connection language (set in connection string or with SET LANGUAGE). This works perfectly well for built-in ...
1
vote
1answer
138 views

Get one column table when doing localization

I have got only one column for a table when i create two localized tables. Code as bellow. -- Month CREATE TABLE `month` ( `id` INT PRIMARY KEY NOT NULL AUTO_INCREMENT, ); -- Month Localized ...
3
votes
0answers
291 views

How to full text search localized enums?

Suppose an SQL database like PostgreSQL with a simple table of products: id | name | type ----+-------------+------- 10 | MacBook | 1 11 | iPhone | 2 12 | Boeing 747 | 3 13 | ...
6
votes
1answer
12k views

Add a new collation to a Postgres database

I have these collations: postgres=# select * from pg_collation; collname | collnamespace | collowner | collencoding | collcollate | collctype ------------+---------------+-----------+------------...
3
votes
1answer
2k views

Confused over encoding/locale in postgresql

I am a little confused over the difference between encoding and locale as it pertains to the postgresql database. When initializing the database, you can specify both an encoding and a locale. ...
0
votes
2answers
2k views

How to use Italian locale for Postgres messages

On Oracle I have set: export NLS_LANG=Italian_ITALY.UTF8 .. on Unix shell and now I get status and error message in Italian. How to set in Postgres shell (psql)? I have set: SET lc_messages TO '...