dasvinay
asked on
Equivalent of sqlserver's COLLATE in Oracle
Hi,
What is the equivalent of 'COLLATE' in Oracle 91 ? Does oracle need it ?
I am trying to migrate some sqlserver scripts into oracle.
create table [Stats] (
[id] [int] not null,
[entity] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_ AS NULL
) ON [PRIMARY];
CREATE INDEX [IX_UserID] ON [Stats]([id]) ON [PRIMARY];
Thanks
What is the equivalent of 'COLLATE' in Oracle 91 ? Does oracle need it ?
I am trying to migrate some sqlserver scripts into oracle.
create table [Stats] (
[id] [int] not null,
[entity] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_
) ON [PRIMARY];
CREATE INDEX [IX_UserID] ON [Stats]([id]) ON [PRIMARY];
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent Man !! Thanks
Also, you should change all varchar fields to varchar2 (for ORACLE), and also drop the [ and ] from the SQL for the table definitions.
AW