By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,636 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

Reducing Data type Lenght

P: 16
Hi There
I m using sql server. I have a column Name nvarchar(max) in table.Now I want to change datatype nvarchar(max) to nvarchar(4000).Will the data be truncated automatically?
if 'Yes',How data will be truncated. i.e. from left ,from right or any part.

Is this truncation depends on Sql server version also?
Awaiting Your response
Nov 27 '09 #1
Share this Question
Share on Google+
2 Replies


ssnaik84
100+
P: 149
Now I want to change datatype nvarchar(max) to nvarchar(4000).
why do you want this change??

For SQL SERVER,
nvarchar(max) == nvarchar(4000)
varchar(max) == varchar(8000)
Nov 27 '09 #2

nbiswas
100+
P: 149
Yes there will be data truncation from right to left
Nov 30 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.