storing wide characters or multibyte using pro*c

Hello

I have a question about using wide characters in oracle...

In my application I want to handle all possible languages and simply wish to map the wchar_t type to the oracle database. The wchar_t type in Solaris is 4bytes so if I can store 4 byte chars in oracle that would seem most sensible.

The database was created with UTF8 character set so I tried
create table t(c nchar(20));
insert into t values(N'asdf');
This much worked fine
Now when I try from a pro*c application
char nls_char *password[] = "asdf";
insert into t values (:password);

I get a -12704(?) error invalid character set If I set

Is there a good reference on how to store unicode in oracle tables using pro*c??

I tried compiling with proc NCHAR_NLS=password and setting the NCHAR_(something else)=UTF8 in the environment This resulted in another error sql invalid character set...

Confusing to say the least

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jul 14 2000 - 00:00:00 CDT