Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

1
vote
0answers
180 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 ...
4
votes
1answer
827 views

Postgres - Encoding, Collation and CType

List of databases Name | Owner | Encoding | Collate | Ctype | -------------------------+----------+----------+---------------------------...
0
votes
1answer
88 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
161 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
488 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, ...
2
votes
1answer
86 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 ...
1
vote
1answer
511 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
164 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 +------+-----------------------+----------------...
3
votes
1answer
248 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
124 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 ...
1
vote
1answer
446 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; ...
3
votes
0answers
265 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
11k views

Add a new collation to a Postgres database

I have these collations: postgres=# select * from pg_collation; collname | collnamespace | collowner | collencoding | collcollate | collctype ------------+---------------+-----------+------------...
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 '...
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 ...
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. ...