More Unicode

Question

More Unicode

Steve Jones - SSC Editor

SSC Guru

Points: 734449
More actions
May 5, 2016 at 9:36 pm

#307358

Comments posted to this topic are about the item More Unicode

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

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

Felix Pamittan Mr or Mrs. 500 Points: 535 More actions · Answer 1

Correct answer:
Yes, you can run this code, This returns 97
Explanation:
You can run this code. The CHAR variable is converted to NCHAR and the first character's value returned. An upper case 'A' is 65. Same as ASCII.

I think the answer should be:

Yes, you can run this code, This returns 65

The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url]

Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs[/url]

SADSAC SSCrazy Points: 2329 More actions · Answer 2

Felix Pamittan (5/5/2016)
Correct answer:
Yes, you can run this code, This returns 97
Explanation:
You can run this code. The CHAR variable is converted to NCHAR and the first character's value returned. An upper case 'A' is 65. Same as ASCII.
I think the answer should be:
Yes, you can run this code, This returns 65

Agree.

"A" is 65 in both ASCII and UNICODE lists.

HappyGeek SSCoach Points: 18726 More actions · Answer 3

SADSAC (5/5/2016)
Felix Pamittan (5/5/2016)
Correct answer:
Yes, you can run this code, This returns 97
Explanation:
You can run this code. The CHAR variable is converted to NCHAR and the first character's value returned. An upper case 'A' is 65. Same as ASCII.
I think the answer should be:
Yes, you can run this code, This returns 65
Agree.
"A" is 65 in both ASCII and UNICODE lists.

Agreed

...

Carlo Romagnano SSC-Insane Points: 22599 More actions · Answer 4

Carlo Romagnano

SSC-Insane

Points: 22599

May 6, 2016 at 12:48 am

#1877030

😎

Michael Riemer SSCertifiable Points: 5190 More actions · Answer 5

HappyGeek (5/5/2016)
SADSAC (5/5/2016)
Felix Pamittan (5/5/2016)
Correct answer:
Yes, you can run this code, This returns 97
Explanation:
You can run this code. The CHAR variable is converted to NCHAR and the first character's value returned. An upper case 'A' is 65. Same as ASCII.
I think the answer should be:
Yes, you can run this code, This returns 65
Agree.
"A" is 65 in both ASCII and UNICODE lists.
Agreed

Yup - love it when the explanation has the right answer but still marks you wrong...

Neil Burton SSC-Insane Points: 22908 More actions · Answer 6

Felix Pamittan (5/5/2016)
Correct answer:
Yes, you can run this code, This returns 97
Explanation:
You can run this code. The CHAR variable is converted to NCHAR and the first character's value returned. An upper case 'A' is 65. Same as ASCII.
I think the answer should be:
Yes, you can run this code, This returns 65

+1

On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

dm 16849 SSC Journeyman Points: 94 More actions · Answer 7

dm 16849

SSC Journeyman

Points: 94

May 6, 2016 at 1:09 am

#1877035

Agree

Toreador SSChampion Points: 11358 More actions · Answer 8

This is a disgrace I demand you give me the points that have been stolen from me in fact I want double points as compensation for the distress caused I'm going to call a lawyer

edwardwill SSCertifiable Points: 5790 More actions · Answer 9

edwardwill

SSCertifiable

Points: 5790

May 6, 2016 at 1:36 am

#1877041

Another borked QotD.

Mauricio_ SSCrazy Points: 2935 More actions · Answer 10

Mauricio_

SSCrazy

Points: 2935

May 6, 2016 at 1:37 am

#1877042

I'm confused. Right answer is 65, isnt' it?

tripleAxe SSCertifiable Points: 5706 More actions · Answer 11

Stuff it! I got it wrong again!

Well.. that one got me double-checking and triple checking and actually running the code in 3 different versions of SQL server. Maybe I should read the discussion about the QotD first 🙂

Hey-ho, all good fun.

tripleAxe SSCertifiable Points: 5706 More actions · Answer 12

upper case / lower case confusion?

SELECT UNICODE(N'a'); ---returns 97

SELECT UNICODE(N'A'); --returns 65

taz.higgins Valued Member Points: 64 More actions · Answer 13

The textual explanation of the answer is right.

The actual answer set to be right is wrong. 🙂

mjagadeeswari SSC-Addicted Points: 454 More actions · Answer 14

taz.higgins (5/6/2016)
The textual explanation of the answer is right.
The actual answer set to be right is wrong. 🙂

yeah exactly.:-)