Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-109220

When creating SQLServer tables in Liferay, we still use the image type for Blobs even though its deprecated

Details

    Description

      Looking at the SQL Server documentation, the image type used as Blob is currently deprecated and will be removed in a future version. Although it is still usable, we should look a way to move over / have upgrade processes for these tables to prevent issues with SQL Server in the future.
      https://docs.microsoft.com/en-us/sql/t-sql/data-types/ntext-text-and-image-transact-sql?redirectedfrom=MSDN&view=sql-server-ver15

      The templates in SQLServerDB.java currently create SQLServer tables within Liferay that are of type Blob with data type image. The recommended usage in SQLServer is varbinary(MAX). If you check hibernate's dialect SQLServer2005Dialect, they also use varbinary(MAX) to represent blobs in SQLServer. However we still use the image type, and we will need to eventually move out of that data type in the future if we want to use future versions of SQL Server where they remove the deprecated variable type 'image'.

      Attachments

        Activity

          People

            support-lep@liferay.com SE Support
            kyle.miho Kyle Miho
            Kiyoshi Lee Kiyoshi Lee
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:

              Packages

                Version Package