Can anyone know what is the difference between nvarchar and text ? I think nvarchar is used to store unicode data, which is used to store multilingual data in our database tables.
Printable View
Can anyone know what is the difference between nvarchar and text ? I think nvarchar is used to store unicode data, which is used to store multilingual data in our database tables.
Variable-length Unicode character data of n characters. n must be a value from 1 through 4,000. Storage size, in bytes, is two times the number of characters entered. The data entered can be 0 characters in length. The SQL-92 synonyms for nvarchar are national char varying and national character varying.
When n is not specified in a data definition or variable declaration statement, the default length is 1. When n is not specified with the CAST function, the default length is 30.