nchar inserts in Oracle 8i

[shyamal]

A typical insert for an nchar field does not work:

insert into DEV.SLEONTPS (FLDNCHAR) VALUES ("test&quot

I was told to use this:

insert into DEV.SLEONTPS (FLDNCHAR) VALUES TRANSLATE("test" USING NCHAR_CS);

This still errors out with the following;
ORA-00906: missing left parenthesis

 

[rcurva]

I am no expert on this NCHAR thing but can you replace " (double)with ' (single) instead, SUCH AS;

insert into DEV.SLEONTPS (FLDNCHAR) VALUES ('test')

OR

insert into DEV.SLEONTPS (FLDNCHAR) VALUES TRANSLATE('test' USING NCHAR_CS);

 

[shyamal]

Thanks,
Actually the translate did not work. What worked was:

insert into DEV.SLEONTPS (FLDNCHAR) VALUES (N'test')

Thanks once again!