Additional VARCHAR VARGRAPHIC VARBINARY ROWID and XML fields considerations


For these data types, a two-byte length precedes the character, graphic, or hexadecimal data.

The length does not include the two-length bytes. For VARCHAR, VARBINARY, ROWID, and XML, the length is the number of bytes. For VARGRAPHIC, the length is the number of double-byte characters.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*