Oracle PL/SQL Tutorial/SQL Data Types/character Unicode

"character varying" column

   <source lang="sql">

SQL> create table foo (

 2        a   integer,
 3        b   dec( 9, 2 ),
 4        c   character varying( 30 ),
 5        d   national char( 3 )
 6      )
 7      /

Table created. SQL> describe foo

Name                         Null?    Type
--------------------------- -------- --------------------------------------------------------------------------------------------------------------------
A                                     NUMBER(38)
B                                     NUMBER(9,2)
C                                     VARCHAR2(30)
D                                     NCHAR(3)

SQL> SQL> SQL> drop table foo; Table dropped.</source>

"national char" type column

   <source lang="sql">

SQL> create table foo (

 2        a   integer,
 3        b   dec( 9, 2 ),
 4        c   character varying( 30 ),
 5        d   national char( 3 )
 6      )
 7      /

Table created. SQL> describe foo

Name                         Null?    Type

---

A                                     NUMBER(38)
B                                     NUMBER(9,2)
C                                     VARCHAR2(30)
D                                     NCHAR(3)

SQL> SQL> SQL> drop table foo; Table dropped.</source>