SQLTeam.com | Weblogs | Forums

Error message when creating table

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?

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

Thank you what can i change this for

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

Instead of "varchar2" use "nvarchar".