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
1
vote
1answer
24 views

Querying for a specific language and if not found use default one instead

I currently store all language data (including default language) in my database. Generally a simple query making the assumption the language exists is as simple as doing: SELECT a.artifact_id, ...
3
votes
1answer
38 views

Setting up relationships on a gaming schema with multiple locales

I've devised the following schema: Where BotLocale holds locales like en-US, es-AR, etc. GameArtifact has a primary key which is artifact_id and GameClass with locale, identifier being the primary ...
0
votes
1answer
50 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
534 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
516 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
139 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 ...
7
votes
1answer
3k views

Postgres - Encoding, Collation and CType

List of databases Name | Owner | Encoding | Collate | Ctype | -------------------------+----------+----------+---------------------------...
1
vote
1answer
230 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
196 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
830 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
6k 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
765 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
323 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
299 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
142 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
330 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
14k 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
3k 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 '...