René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Cannot understand FILESTREAM","articleBody":"Is there support for filestream fields? As far as I know, you can just treat them like binary(max) and query them like other fields, but the converter seems to be choking on mine. Is this expected behaviour?\r\nThe error looks like this:\r\n```\r\nCannot understand       [ScanData] [varbinary](max) FILESTREAM  NULL,\r\n\r\n at ./sqlserver2pgsql.pl line 1663, \u003c$file\u003e line 2132.\r\n        main::parse_dump() called at ./sqlserver2pgsql.pl line 3317\r\n```\r\nThe schema.sql file has this table definition and the filestream field is the last one.\r\n```/****** Object:  Table [dbo].[BitMapsFarm]    Script Date: 2/03/2023 1:20:56 PM ******/\r\nSET ANSI_NULLS ON\r\nGO\r\nSET QUOTED_IDENTIFIER ON\r\nGO\r\nCREATE TABLE [dbo].[BitMapsFarm](\r\n        [FarmBitMapID] [int] IDENTITY(1,1) NOT NULL,\r\n        [BitMapTypeID] [int] NULL,\r\n        [bmpName] [nvarchar](50) NULL,\r\n        [DateFrom] [datetime] NULL,\r\n        [DateTo] [datetime] NULL,\r\n        [WayPointID_1] [int] NULL,\r\n        [WayPointID_2] [int] NULL,\r\n        [mx1] [int] NULL,\r\n        [my1] [int] NULL,\r\n        [mx2] [int] NULL,\r\n        [my2] [int] NULL,\r\n        [Aspect] [float] NULL,\r\n        [Minx] [float] NULL,\r\n        [Miny] [float] NULL,\r\n        [Maxx] [float] NULL,\r\n        [Maxy] [float] NULL,\r\n        [Zone] [int] NULL,\r\n        [upsize_ts] [timestamp] NULL,\r\n        [ScanGUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL,\r\n        [ScanData] [varbinary](max) FILESTREAM  NULL,\r\n CONSTRAINT [aaaaaBitMapsFarm_PK] PRIMARY KEY CLUSTERED\r\n(\r\n        [FarmBitMapID] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] FILESTREAM_ON [ImageFileStream],\r\nUNIQUE NONCLUSTERED\r\n(\r\n        [ScanGUID] ASC\r\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\r\n) ON [PRIMARY] FILESTREAM_ON [ImageFileStream]\r\nGO\r\n```","author":{"url":"https://github.com/allaboutmikey","@type":"Person","name":"allaboutmikey"},"datePublished":"2023-03-02T05:04:37.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/175/sqlserver2pgsql/issues/175"}