Home Search Pricing Get inErrata About

Sign in Sign up

Graph/e1eb4cf9-dd22-4292-ab89-90d80ed7895e

Domainunvalidated

Locale

e1eb4cf9-dd22-4292-ab89-90d80ed7895e

Locale

Node Details

Public graph metadata

Updated5/1/2026

PageRank0.0001

Effectiveness0.000

Connections

9 linked nodes

PERTAIN_TOProblem

my backend is nodejs. Tension: How letters are converted to lower case depends on the locale implementation. Outcome: you should not assume that lower-casing in Javascript works the same as lower-casing in PostgreSQL.

PERTAIN_TOSolution

Tension: which is not the default, and that you use the same locale as you are using in Javascript. Outcome: create your PostgreSQL database with an ICU locale.

PERTAIN_TOProblem

pgAdmin 4 only shows 3 collations in the database collation menu

PERTAIN_TOSolution

Update to PGAdmin 7.7 or above, where those parameters are exposed through the database dialog

PERTAIN_TOSolution

Run CREATE DATABASE in a regular SQL window with template0, locale_provider icu, and icu_locale set explicitly

PERTAIN_TOProblem

E and É are treated as equals — for example, E and É are treated as equals. Tension: the traditional Hungarian dictionary order (A < Á < B < C < Cs … E < É) is not applied by default. Outcome: No built-in Java Collator implements the full Hungarian dictionary alphabet.

PERTAIN_TOSolution

No built-in Java Collator implements the full Hungarian dictionary alphabet. — If you need the real Hungarian dictionary order. Tension: you must use a tailored collation. Outcome: Collator.getInstance(new ULocale("hu@collation=dictionary")).

PERTAIN_TOProblem

a time zone abbreviation such as `PST` — whether the user is in the Philippines, US, Canada, etc. Tension: both provide an exhaustive list and don't give any guidance on which to pick. Outcome: a lot closer than having to guess when we get an ambiguous time zone as input.

PERTAIN_TOSolution

you need to use `ZoneId.of(String, Map)` method — To be able to use the ambiguous short IDs. Tension: the map provides the mapping between unsupported names and a supported name. Outcome: you'll need to provide said mapping yourself with a custom `Map`.

[inerrata]Tags Knowledge Graph Docs About Pricing Contact Report a Bug Privacy Terms Cookie Settings Do Not Sell or Share My Info

© 2026 Inerrata

Locale - inErrata Knowledge Graph | Inerrata