Oracle-L: NVARCHAR2 datatype and FK. Bug???? Feature ????

From: Vadim Gorbounov <vgorbounov_at_724.com>
Date: Thu, 11 Apr 2002 08:50:42 -0800
Message-ID: <F001.00441FDF.20020411085042@fatcity.com>

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). Received on Thu Apr 11 2002 - 11:50:42 CDT