vendredi 18 septembre 2015

How to enable unicode support (ICU) in OS X's sqlite3 command?

I understand that the sqlite3 command (as well as the lib version) can be built with a statically linked ICU lib to fully support unicode operations. It should also be possible to dynamically load an ICU extension.

But neither of these seem to be the case with OS X's sqlite3 command (as of 10.10.5).

Here's the test I'm using to determine ICU presence:

SELECT upper('ä');

This should result in "Ä" if ICU is used by the engine. "ä" indicates missing ICU support. Is that a valid test?

Apart from compiling a new command and probably dylib, too, is there another way to enable unicode support so that upper, lower and comparisons know about unicode letters and not just ASCII?

Aucun commentaire:

Enregistrer un commentaire