Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: NVARCHAR2 datatype and FK. Bug???? Feature ????
BUG.
Fixed in 9i.
-----Original Message-----
Sent: Thursday, April 11, 2002 12:51 PM
To: Multiple recipients of list ORACLE-L
Hi everybody,
Oracle 8.1.7.2, Solaris.
What is your opinion on this? Seems, Metalink doesn't have any :(
SQL> create table test_pk(
2 id nvarchar2(20) primary key
3 );
Table created.
SQL> create table test_Fk(
2 id nvarchar2(20),
3 constraint c_test_FK foreign key(id) references test_pk(id) on delete
cascade);
Table created.
SQL> insert into test_pk values (N'1');
1 row created.
SQL> insert into test_fk values (N'1');
1 row created.
SQL> commit;
Commit complete.
SQL> delete from test_pk ;
delete from test_pk
*
ERROR at line 1:
ORA-12704: character set mismatch
TIA
Vadim Gorbounov
Oracle DBA
724 Solutions Inc.
Tel:(416)226-2900 ext 5070
Email: vgorbounov_at_724.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vadim Gorbounov
INET: vgorbounov_at_724.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Apr 11 2002 - 15:33:38 CDT
![]() |
![]() |