What is the max for nvarchar data type in SQL?

[emilyng]

Hi there,

Can I know how many character (max) that can be entered into a nvarchar data type?

 

[guljar]

4000

 

[mkuan]

Do you know what what datatype in SQL Server 6.5 that can handle as many characters?

I need to create a sproc that contain an input parameter that can take more than 255 (max of vchar) characters.

Pls help.

Thx.


Min.

 

[RickCole]

If you need to have a field of more then 255 characters in 6.5 you need to use the data type ‘text’.

Rick.

 

[mkuan]

According to documentation...

nvarchar:
Variable-length Unicode data with a maximum length of 4,000 characters. sysname is a system-supplied user-defined data type that is a synonym for nvarchar(128) and is used to reference database object names.

 

[mkuan]

Thx, RickCole for the tips.