SQL 'image' Vs. 'varbinary(max)'

[Zohar]

Hi all,

We are using an 'image' data type as the sql type when we need to use blobs in our application.

As Microsoft states here:  https://docs.microsoft.com/en-us/sql/t-sql/data-types/ntext-text-and-image-transact-sql?view=sql-server-2017, data type 'image' is deprecated and will be removed in one of the future versions of sql.

Does anyone have any experience using the varbinary(max) with the ByteArrayColumn in Firefly.Box code? does it work seamlessly? or do We have to do some adjustments?

Any information regarding this issue will be greatly appreciated.

Zohar

[Noam Honig]

Should work - we've seen it in multiple migrations.

On Wed, Jun 27, 2018 at 10:39 AM Zohar <zo...@tbh.co.il> wrote:

Hi all,

We are using an 'image' data type as the sql type when we need to use blobs in our application.

As Microsoft states heer:  https://docs.microsoft.com/en-us/sql/t-sql/data-types/ntext-text-and-image-transact-sql?view=sql-server-2017, data type 'image' is deprecated and will be removed in one of the future versions of sql.

does anyone have any experience using the varbinary(max) with the ByteArrayColumn in Firefly.Box code? does it work seamlessly? or do We have to do some adjustments?

Any information regarding this issue will be greatly appreciated.

Zohar

--
You received this message because you are subscribed to the Google Groups "Migrated By Firefly" group.
To unsubscribe from this group and stop receiving emails from it, send an email to migrated-by-fir...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Zohar]

Hi Noam,

Thank you for your lightning fast reply.

We'll give it a try and report back.

[Zohar]

Works without any issues.