What is in the Blank space? Data Type is NVarChar

Question

Viewing 4 posts - 1 through 5 (of 5 total)

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

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 1

Try this:

Select DATALENGTH(FirstName), CONVERT(VARBINARY(MAX), FirstName) From Person

If DATALENGTH returns zero there is nothing within your column, otherwise the second column shows the binary data.

Greets

Flo

GSquared SSC Guru Points: 260824 More actions · Answer 2

Try:

Select unicode(FirstName) From Person Where FirstName <= 'a'

Then check the value returned against the unicode character set at http://www.unicode.org.

Does that help?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

FelixG SSCrazy Points: 2550 More actions · Answer 3

Your field contains nonprintable characters....

what does return select ascii(right(field_name,1)) ????

Jacob Pressures SSCertifiable Points: 5804 More actions · Answer 4

Weird guys!

Ok i tried each one of your functions returned NULL! I tried all 3. But the IS NULL did not work.

I'm satisfied. At least i was able to do what i wanted to and i learned some things.

Thanks!