Create table with varchar2(1000 char) column in 11gR2
Just doing functional testing with Oracle11gR2 (in preparation for my
Oracle10gR2 upgrade). I came across this create table script.
A
desc table on Oracle10gR2( 10.2.0.4 with July2010 CPU) shows up as
varchar2(1000) but on Oracle11gR2 it is varchar2(1000 char).
Need to understand if this will be a problem if we continue to use this table as it is without modifying it to varchar2(1000).
create table "PORTAL_NOTIFIED"
("USER_ID" VARCHAR2(20),
"OPERATION" VARCHAR2(20),
"NOTIFICATION_NO" VARCHAR2(12),
"MGR_NAME" VARCHAR2(1000 char ),
"NAME" VARCHAR2(1000 char),
"SCHEME_NAME" VARCHAR2(1000 char));
Table created.
SQL> desc DPORTAL_NOTIFIED;
Name Null? Type
----------------------------------------- -------- ----------------------------
Need to understand if this will be a problem if we continue to use this table as it is without modifying it to varchar2(1000).
create table "PORTAL_NOTIFIED"
("USER_ID" VARCHAR2(20),
"OPERATION" VARCHAR2(20),
"NOTIFICATION_NO" VARCHAR2(12),
"MGR_NAME" VARCHAR2(1000 char ),
"NAME" VARCHAR2(1000 char),
"SCHEME_NAME" VARCHAR2(1000 char));
Table created.
SQL> desc DPORTAL_NOTIFIED;
Name Null? Type
----------------------------------------- -------- ----------------------------
0