Share via

2.1.18 NVarChar

  • Article

The NVarChar data type is a user-defined variable-length double-byte character string that has a supported maximum number of double-byte characters that range from 1 through 4000 or "max". "Max" specifies that the data type can store up to 231 – 2(2,147,483,646) bytes' worth of double-byte characters. The values of this data type are represented in simple Unicode string format, as follows.

  
 NVarChar = 0*nOCTET

In this format, n = 2,147,483,646. Because the characters are already in Unicode, there is no conversion. If the value is an empty string, the instance data is %x0000.