Oracle9i: Export NVARCHAR data to flat file using Pro*C

Hi experts,

I am going to export data from an Oracle 9i database column containing Chinese characters of type nvarchar2 to a flat file by writing a pro*C program.

database character set = utf8
national character set = utf16

Can any experts out here tell me:

(i) what header(s) should I include
(ii) how should I declare the host variables
(iii) how should I declare the host variable length
(iv) how should I set the NLS_* (NLS_LANG, NLS_NCHAR any more ?)
environment variables
(v) any compiler options needed to be set for successful compilation ?

Any help is appreciated.

• peter