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.
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.
Bookmarks