Difference with DataLength and Len with CHAR and NVARCHAR Datatype

Question

Post reply

Difference with DataLength and Len with CHAR and NVARCHAR Datatype

Mitesh Oswal

SSCrazy

Points: 2798
More actions
July 10, 2014 at 9:23 pm

#288521

Comments posted to this topic are about the item Difference with DataLength and Len with CHAR and NVARCHAR Datatype
Regards,
Mitesh OSwal
+918698619998

Viewing 15 posts - 1 through 15 (of 18 total)

You must be logged in to reply to this topic. Login to reply

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 1

I have actually thought of this question yesterday :-), I am surprised to see it today.

(of course, I don't have plans to submit as QOTD)

Hardy21 SSCrazy Eights Points: 9708 More actions · Answer 2

Hardy21

SSCrazy Eights

Points: 9708

July 11, 2014 at 12:17 am

#1728606

Easy one for Friday, thanks

Thanks

Koen Verbeeck SSC Guru Points: 259155 More actions · Answer 3

Why is DATALENGTH() included in the question? The first two results are the same for all answers

Nice easy question to end the week, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

domenico.delbrocco SSChasing Mays Points: 617 More actions · Answer 4

domenico.delbrocco

SSChasing Mays

Points: 617

July 11, 2014 at 12:47 am

#1728614

I agree, it's easier than it appears

paul.knibbs SSCoach Points: 15320 More actions · Answer 5

Yeah, it would have made it a bit harder if there had been some variation in the first two numbers--that half of the question might as well have not been there!

Iulian -207023 SSCertifiable Points: 7639 More actions · Answer 6

Iulian -207023

SSCertifiable

Points: 7639

July 11, 2014 at 3:25 am

#1728647

thank you for the question

Ed Wagner SSC Guru Points: 287026 More actions · Answer 7

A nice and easy one to end the week. Thanks.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

manik_anu SSCrazy Points: 2397 More actions · Answer 8

Easy question:-)

Manik
You cannot get to the top by sitting on your bottom.

Nevyn SSChampion Points: 14210 More actions · Answer 9

Nice question, but there should have been a better trap answer. Too many obviously wrong. You could have done a 20,6,10,3 and it may have tripped up some people. A 10,3,3,3 may have gotten some people too.

Dana Medley SSCertifiable Points: 6764 More actions · Answer 10

Thanks for the question. Good one to end the week on.

Everything is awesome!

stephen.long.1 SSCrazy Points: 2591 More actions · Answer 11

Nice question, but I agree with others, there should have been some options where the DATALENGTH results varied. My first instincts (before seeing the available options) were 20,6,10,3, but when I saw that that wasn't one of the options, I thought about it some more and got the right answer.

Thomas Abraham SSChampion Points: 10761 More actions · Answer 12

Liked the question, in spite of issues others have pointed out. Nice easy one for a Friday.

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

jacquereed SSC Journeyman Points: 99 More actions · Answer 13

I'm surprised that you didn't include VARCHAR(10) in your question just to mix things up. FYI, both the datalength and the len are 3 and that is why I use it.

DECLARE @NCHAR NCHAR(10) ='ABC' ,

@NVARCHAR NVARCHAR(10) = 'ABC' ,

@VARCHAR VARCHAR(10) = 'ABC'

SELECT DATALENGTH(@NCHAR),

DATALENGTH(@NVARCHAR),

DATALENGTH(@VARCHAR),

LEN(@NCHAR),

LEN(@NVARCHAR) ,

LEN(@VARCHAR)

damoder.maligireddy Newbie Points: 4 More actions · Answer 14

damoder.maligireddy

Newbie

Points: 4

July 13, 2014 at 1:05 am

#1728974

good question:-)

Difference with DataLength and Len with CHAR and NVARCHAR Datatype

Cookies on SQLServerCentral