Using BSON without utf8 as charset.

Posted in 2018

FLORIAN APOLLONER — Wed, 22 Aug 2018 12:07:04 — source: IIUG Forums & Mailing Lists

I am trying to use BSON/JSON functionality with a database set to de_de.8859-1 as locale. When converting a row to BSON like this: SELECT genbson(testing) from testing; I do get "9660: The database server operation failed due to an invalid JSON document." as soon as I do have umlauts in there. This seems somewhat legit, since JSON strictly requires UTF-8, but I had hoped that informix would convert the data. Is there any way around this? Thanks, Florian