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

            Assignee:
            support-lep@liferay.com SE Support
            Reporter:
            kyle.miho Kyle Miho
            Recent user:
            Kyle Miho
            Participants of an Issue:
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:

                Packages

                Version Package