Hi!

Every doc say that NCHAR (NVARCHAR etc.) supports unicode. I have
created database with command "createdb -n", and tried following:

create table aaa (
string nchar(2)
);
insert into aaa values (U&'\0105');
select hex(nchar(string)) from aaa;

Unfortunately it returns 61 00 28 03 which is garbage, it should be 05
01 20 00.

How does one insert insert unicode data to NCHAR column?

Thanks,
Tomasz

Hi,
I tried that in an NFC, rather than NFD, installation; it gave the
results you expect.
Try createdb -i instead of createdb -n.
GJ


--
geraintjones

Thanks a lot, it works like a charm

W dniu 2012-04-25 16:43, Ingres Forums pisze:

Hi Tomasz,
createdb -n creates a database that uses NFD normalisation resulting in
composite characters, such as 0105 being decomposed.
Instead of -n, use -i to retain NFC form which you seem to be expecting.
Regards,
Ian

-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Tomasz Konojacki
Sent: 25 April 2012 15:23
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: [Info-Ingres] How to insert unicode data into NCHAR column?

Hi!

Every doc say that NCHAR (NVARCHAR etc.) supports unicode. I have
created database with command "createdb -n", and tried following:

create table aaa (
string nchar(2)
);
insert into aaa values (U&'\0105');
select hex(nchar(string)) from aaa;

Unfortunately it returns 61 00 28 03 which is garbage, it should be 05
01 20 00.

How does one insert insert unicode data to NCHAR column?

Thanks,
Tomasz
_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres