insert data to Unicode database table with "N"

Hi, I was wondering how to insert data to a Unicode database table with "N" character without getting the expected "ORA-12704: character set mismatch" error.

Below is the insert command I used to grab data from a db link (a non-  Oracle DB). The target table's "COMMENT" column is a NVARCHAR type and I currently having trouble formatting the "insert into..select" statement that meet the prefixing "N" requirement. In the statement below, I had commented out the original "COMMENT" column and attempt to do the "N" character...but run into the ORA-12704 error.

SYSTEM SPEC: Oracle 8.0.6 in NT4with Unicode character set.

BTW, I can insert if I use the "INSERT... VALUES (N'text')..." method. Please advise. TIA.

INSERT INTO STANDARD_RESPONSE
NOLOGGING

	(RESPONSE_ID,
	 QUESTION_SEQ,
	 QUESTION_ID,
	 TQ_ID,
	 IMPORTANCE_RESP,
	 PERFORMANCE_RESP,
	 COMMENTS,
	 TRIG_COMMENTS,
	 TQ_DESC,
	 OTHER_TEXT,
	 TRIG_OTHER_TEXT)
SELECT
	RESPONSE_ID,
	QUESTION_SEQ,
	QUESTION_ID,
	NULL,
	IMPORTANCE_RESP,
	PERFORMANCE_RESP,
	'N' || COMMENTS,
	--- COMMENTS,
	NULL,
	NULL,
	NULL,
	NULL

--
Remove no "_NoSpam" to email.


Sent via Deja.com
http://www.deja.com/