Hi

I have drop database and recreated again with UTF8 character set but it is still not working for me. Can you tell me which is supported character set that will accept unicode characters.

see the example below. I have logged in with sys as sysdba

SQL> CREATE TABLE EMP (ENO NUMBER (10), NAME NVARCHAR2 (50) )
2 TABLESPACE MASTERS_DATA;

Table created.

SQL> ALTER TABLE EMP MODIFY("NAME" DEFAULT 0);
ALTER TABLE EMP MODIFY("NAME" DEFAULT 0)
*
ERROR at line 1:
ORA-02262: ORA-%05d occurs while type-checking column default value expression


SQL> DROP TABLE EMP;

Table dropped.

SQL> CREATE TABLE EMP (ENO NUMBER (10), NAME VARCHAR2 (50) )
2 TABLESPACE MASTERS_DATA;

Table created.

SQL> ALTER TABLE EMP MODIFY("NAME" DEFAULT 0);

Table altered.