Database Administrators Stack Exchange
Database Administrators 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.

Use the for issues such as character set of the database, localization based on the server location and client location, etc.

Example: The number 1776.3 could be displayed differently in the United States and Italy:

    Country         Results
    -------------   -------
    United States   1,776.3
    Italy           1.776,3
25 questions
18
votes
1 answer

Postgres - Encoding, Collation and CType

List of databases Name | Owner | Encoding | Collate | Ctype …
Rob P.
  • 283
  • 1
  • 2
  • 6
14
votes
1 answer

Why does a comparison between 'tr' & 'tR' fail on a SQL Server with Vietnamese_CI_AI collation?

There seems to be something special about 'tR' in Vietnamese collation. Appreicate if anyone who knows about it can explain in simple terms. This issue was discovered during the installation of our product on a "Vietnamese" collated SQL Server. One…
QFirstLast
  • 451
  • 2
  • 11
7
votes
1 answer

Add a new collation to a Postgres database

I have these collations: postgres=# select * from pg_collation; collname | collnamespace | collowner | collencoding | collcollate | collctype ------------+---------------+-----------+--------------+-------------+----------- default | …
José Luis
  • 215
  • 1
  • 3
  • 7
4
votes
1 answer

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. Correct me if I am wrong but I assume the encoding…
user972276
  • 309
  • 1
  • 4
  • 13
4
votes
1 answer

SQL Server with French_CI_AS Collation date conversion

I have a French installation of SQL Server using French_CI_AS Collation. For legacy reasons, a table column stores data as VARCHAR which is later converted to the right type, akin to variant in C++. Two rows in this column have data as: 2020-10-12…
Niraj Srivastava
  • 41
  • 1
  • 3
3
votes
1 answer

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 key. How can I properly set up a relationship…
Dimbreath
  • 79
  • 5
3
votes
1 answer

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, the locale of the database can be set during…
hanxue
  • 245
  • 1
  • 4
  • 10
3
votes
1 answer

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 | MacBook Pro | 1 type is an ID from a separate table…
vektor
  • 411
  • 1
  • 5
  • 16
2
votes
2 answers

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 solution for a problem that was more or less easy to…
user5613506
  • 295
  • 1
  • 2
  • 6
2
votes
1 answer

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 applications. ICU is widely portable and gives applications…
Hamid
  • 21
  • 1
2
votes
1 answer

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 +------+-----------------------+----------------+ | ID | TITLE | AUTHOR …
Giovanni Lovato
  • 465
  • 2
  • 5
  • 15
2
votes
1 answer

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 languages, but there are just 34 of them and I'd…
Arthur Stankevich
  • 121
  • 2
1
vote
2 answers

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 varchar2(32767); response_env varchar2(32767);…
ajeh
  • 911
  • 5
  • 14
  • 31
1
vote
1 answer

Collation for accent-insensitive comparison on Postgres?

On PG 13 documentation, there are several examples of ICU collations for specialized purposes. It is also mentioned that ICU locales exist that allow creating collations to ignore accents, and that they can be found on…
ARX
  • 1,509
  • 3
  • 14
  • 15
1
vote
1 answer

Can I set in MariaDB the collation based on a IETF language tag?

I have an application where each user account can set their preferred application language. I store those language preferences as IETF BCP47 language tag (e.g. "de", "en-US"). Now, for queries for that user, I want to sort the results based on their…
Florian
  • 113
  • 5
1
2