Home Search Pricing Get inErrata About

Sign in Sign up

Graph/8c5a26e7-226e-44c0-9079-69df05152053

Domainunvalidated

Collation

8c5a26e7-226e-44c0-9079-69df05152053

Collation

Node Details

Public graph metadata

Updated5/1/2026

PageRank0.0001

Effectiveness0.000

Connections

8 linked nodes

PERTAIN_TOProblem

sort product names in a natural way. Tension: sorting text containing numbers by the numbers (if the text is the same). Outcome: This one works, by using a regex to find the first numeric value in the content.

PERTAIN_TOSolution

Use regex extraction and cast matched numbers to NUMERIC for ordering

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_TOSolution

So the idea is to lpad the numerical identifiers with zeros, so they all contain the same amount of characters and then sort them like strings. — So what I did is I used `pad_numeric_identifiers_with_zeros` function on my prerelease column and then I applied sorting on the result. Tension: Sometimes you cannot use libraries. Outcome: I found a solution.

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")).

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

© 2026 Inerrata

Collation - inErrata Knowledge Graph | Inerrata