SQLTeam.com | Weblogs | Forums

Error message when creating table


#1

hi guys

i am getting the following error message when i try to create a table

Msg 2715, Level 16, State 6, Line 1
Column, parameter, or variable #1: Cannot find data type VARCHAR2.

this is the code which i am running

CREATE TABLE TEST_TAB1
(
SYSTEM1 VARCHAR2(10),
GROUP1 NUMBER,
REPORT_DATE DATE,
T_NAME VARCHAR2(10),
C_NAME VARCHAR2(10),
U_NAME VARCHAR2(10));

any idea why?

how can i correct this?


#2

I belive varchar2 is Oracle specific and it would treat empty string same as null.


#3

Thank you what can i change this for


#4

You can use varchar for non-unicode characters or nvarchar for unicode characters.


#5

Instead of "varchar2" use "nvarchar".