Skip to main content
Microsoft Idea

    Synapse

    Planned

    extent storage capacity of varchar(8000) to varchar(max)

    Vote (44) Share
    Christoph Mettler's profile image

    Christoph Mettler on 30 May 2023 11:45:19

    The maximum string length of 8000 is often considered too short to store longer descriptive data or embed a JSON value within a text field in a database. Dividing the data into smaller chunks and store them across multiple text fields or in separate tables is unnecessarily cumbersome.

    data types ref: CREATE TABLE - SQL Server | Microsoft Learn

    Bogdan Crivat (administrator)

    We're working on this. We'll share details as soon as we have a clear timeline.

    Comments (2)
    Christoph Mettler's profile image Profile Picture

    Derek Williams on 04 Oct 2023 04:00:54

    RE: extent storage capacity of varchar(8000) to varchar(max)

    Hope this gets resolved soon. I've noticed issues with shortcuts in lakehouses and field types that go beyond varchar(8000) are causing errors on the SQL endpoint.

    Christoph Mettler's profile image Profile Picture

    Bogdan Crivat on 14 Sep 2023 23:35:15

    RE: extent storage capacity of varchar(8000) to varchar(max)

    We're working on this. We'll share details as soon as we have a clear timeline.