Conversion

• zeo

  SSC Eights!

  Points: 914

  More actions

  November 13, 2003 at 12:28 pm

  #160183

  I'm attempting to convert this SQL CREATE TABLE script into an Oracle DDL. But I'm not sure how the 'ntext' & TEXTIMAGE_ON attributes translate to Oracle. Can someone assist?

  if exists (select * from dbo.sysobjects where id = object_id(N'[standards].[CSG Special Request Reasons]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

  drop table [standards].[CSG Special Request Reasons]

  GO

  CREATE TABLE [standards].[CSG Special Request Reasons] (

  [Code] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

  [Short Description] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

  [Definition] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

  [Stop Date] [smalldatetime] NULL

  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

  GO

• vambati

  SSCrazy

  Points: 2769

  More actions

  November 13, 2003 at 1:20 pm

  #481951

  They have CBLOB datatype which can hold 4GB of data

• zeo

  SSC Eights!

  Points: 914

  More actions

  November 13, 2003 at 1:49 pm

  #481963

  CBLOB is the oracle datatype that can be used for both ntext and TEXTIMAGE_ON datatypes?

• vambati

  SSCrazy

  Points: 2769

  More actions

  November 13, 2003 at 1:54 pm

  #481965

  Basically when an ntext datatype is used you have textimage_on on that table. Its not a datatype.