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
July 11, 2014 at 9:06 am

This was removed by the editor as SPAM

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: 259115 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: 2377 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: 2582 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)