Project

General

Profile

Feature #6441

compatible collation for UTF-8 databases

Added by Eric Faulhaber almost 2 years ago. Updated almost 2 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Target version:
-
Start date:
Due date:
% Done:

0%

billable:
No
vendor_id:
GCD
version:

Related issues

Related to Database - Feature #6348: implement support for MariaDB WIP

History

#1 Updated by Eric Faulhaber almost 2 years ago

We currently match legacy database collation for non-UTF-8 databases (at least for Linux-based PostgreSQL) by installing a custom locale which defines a collation compatible with the original database. We define various locales to match particular combinations of character encoding and locale.

This is manageable when the character set is limited to 256 characters, but we need a more manageable strategy for Unicode databases. ICU (https://icu.unicode.org/) seems a likely solution, but we need to determine how best to use it across the various databases and OS platforms we need to support.

#2 Updated by Eric Faulhaber almost 2 years ago

Also available in: Atom PDF