Anyone experienced with combination Clarion - SQL Server FILESTREAM
Currently when I have to insert PDF,WORD documents in database , two tables are involved
CREATE TABLE [dbo].[PD_FL]( [SysID] [int] NOT NULL, [GUID] [char](16) NOT NULL, [UseGUIDFilename] [tinyint] NOT NULL, [StorageMethod] [char](4) NOT NULL, [StorageMedium] [char](8) NOT NULL, [BlobFileName] [char](255) NULL, [OriginalFileNameAndPath] [varchar](511) NOT NULL, [StoredFileNameAndPath] [varchar](511) NULL, [FileName] [char](255) NOT NULL, [FileExtension] [char](20) NULL, [FileDate] [int] NULL, [FileTime] [int] NULL, [FileSizeBytes] [int] NULL, [FileSizeKB] [int] NULL, [FileDescription] [char](255) NULL, [FileType] [char](20) NOT NULL, [FileCategory] [char](20) NULL ) ON [PRIMARY] CREATE TABLE [dbo].[PD_DB]( [BlobData] [image] NULL, [GUID] [char](16) NOT NULL, CONSTRAINT [KeyByGUID] PRIMARY KEY CLUSTERED ( [GUID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO
In table [PD_DB] , Clarion field [BlobData] is defined as BLOB,BiNARY .
Everything works fine.
I am trying to implement FILESTREAM on SQL Server .
Filestream says that you need to add another field [FileStreamDataGUID] , and “big data field” has to be VARBINARY(MAX)
Example script for sql table creation :
CREATE TABLE [FileStreamDataStorage] ( [GUID] [char](16) NOT NULL, [FileStreamData] VARBINARY(MAX) FILESTREAM NULL, [FileStreamDataGUID] UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL UNIQUE DEFAULT NEWSEQUENTIALID() ) ON [PRIMARY] FILESTREAM_ON FileStreamGroup GO
Question is :
What is Clarion datatype for VARBINARY(MAX) , maybe same as previous (BLOB,BiNARY) .
Also SQL Server data type UNIQUEIDENTIFIER ROWGUIDCOL, Clarion equivalent ?