Binding NCHAR type.

[benthicsoftware]

Hi all!

I'm trying to create an insert statement with bind variables where one of the columns is a NVARCHAR2. I always seem to get the ORA-12704 error message (character set mismatch). I'm currently using UTF8/USASCII7, but I've also tried a few others with the same results. Anyone have any suggestions? Thanks!

------------------
Mark Ford
Benthic Software
Quality Oracle Tools

 

[benthicsoftware]

Another note:

I've also tried using a dbgrid/oracledataset and I get the same error when I try to insert/update.

------------------
Mark Ford
Benthic Software
Quality Oracle Tools

 

[Marco Kalter]

There is no specific national character set variable type yet in Direct Oracle Access. You can use the translate function instead. For example:

update mytable
set nchar_column = translatestring_var using nchar_cs)
where ...

 

[benthicsoftware]

Thanks Marco! Works perfectly!