home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
14.10.xC10 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

Informix - Problem description

Problem IT37551 Status: Closed

GENBSON() DOES NOT RETURN VALID DATA WITH ACCENTED CHARACTERS

product:
INFORMIX SERVER / 5725A3900 / E10 -
Problem description:
If I issue a select statement using genBSON(), characters with
an accent are displayed incorrectly.

For example, I have a table and insert a single record:

create table t1(
c1 int,
c2 char(10));

insert into t1 values (215, 'Vía');

If I run the following select statement in dbaccess:

select genbson(t2)::JSON from t2 where c1 = 215;


I see this:


(expression)
{"_id":ObjectId("60e4dbf7b7d75c7b00000003"),"c1":215,"c2":"Ví
a

              "}

The data is returned as Vía.
Problem Summary:


Local Fix:




Solution




Workaround


not known / see Local fix


Timestamps


Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

08.07.2021
25.11.2022
25.11.2022


Problem solved at the following versions (IBM BugInfos)




Problem solved according to the fixlist(s) of the following version(s)