Hi Danny,

I can't answer your specific question regarding ODBC but I do know that
Ingres R3 provides full Unicode support so it is possible that the ODBC
driver for that release does as well, however I cannot find an explicit
statement that it does.

One [clunky] option you have is to use the 'COPY' statement to generate CSV
files. This would need to be done on the server or via Ingres Net (not
ODBC).
The basic syntax would be

COPY table (
col1 = c0comma,
col2 = c0comma,
:
:
coln = c0nl) into 'file'

This will result in some white space before the commas in text fields and
after the commas for numeric fields. A quick filter through sed can fix
that.

sed -e 's/[ ]*,[ ]*/,/g' -e 's/[ ]*$//' file

Peter

T: +44 (0)1398 341777
PGale (AT) Comp-Soln (DOT) co.uk
-----Original Message-----
From: info-ingres-admin (AT) cariboulake (DOT) com
[mailto:info-ingres-admin (AT) cariboulake (DOT) com] On Behalf Of dannychok
Sent: 03 October 2005 05:05
To: info-ingres (AT) cariboulake (DOT) com
Subject: [Info-ingres] Dealing with Chinese data using Ingres 2.6

We have some Simp. Chinese data in Ingrest 2.6 on a HP machine. We have
been storing dbl-byte data for years.. but not all front-end can
display them correctly. For example:

- it works for ISQL... so we have a system written in 4GL programs on
HP that works with these Chinese data

- it works for Ingres Visual DBA in Windows with "language for
non-Unicode programs" in "Regional and Lang options" set to "Chinese
(PRC)" and the Ingres Charset variable "II_CHARSETII" set to "ISO88591"
(At DOS prompt, type "ingsetenv II_CHARSETII ISO88591"), which is the
same as server.

- it NEVER work with Ingres ODBC, all Chinese chars become strange
symbols, not readable even with NJ Star opened

Is any way to get it work by ODBC? Cos we need to extract data into
Excel format.

Thanks a lot.

Danny

_______________________________________________
Info-ingres mailing list
Info-ingres (AT) cariboulake (DOT) com
http://mailman.cariboulake.com/mailm...py/info-ingres