IBM Support

nzsql maximum length of CHAR/VARCHAR/NVARCHAR

Question & Answer


Question

What is the maximum length of a CHAR/VARCHAR/NVARCHAR column?

Answer

The maximum length of the CHAR and VARCHAR column is 64,000 characters. The maximum length for NCHAR and NVARCHAR data is 16,000 characters.

[{"Product":{"code":"SSULQD","label":"IBM PureData System"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Database","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.0.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

NZ633239

Document Information

Modified date:
17 October 2019

UID

swg21567857