May 5, 2016 at 9:36 pm
Comments posted to this topic are about the item More Unicode
May 5, 2016 at 11:19 pm
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
May 5, 2016 at 11:43 pm
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.
May 5, 2016 at 11:50 pm
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
...
May 6, 2016 at 12:48 am
May 6, 2016 at 12:59 am
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...
May 6, 2016 at 1:05 am
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
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
May 6, 2016 at 1:09 am
Agree
May 6, 2016 at 1:11 am
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
May 6, 2016 at 1:36 am
Another borked QotD.
May 6, 2016 at 1:37 am
I'm confused. Right answer is 65, isnt' it?
May 6, 2016 at 2:00 am
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.
May 6, 2016 at 2:39 am
upper case / lower case confusion?
SELECT UNICODE(N'a'); ---returns 97
SELECT UNICODE(N'A'); --returns 65
May 6, 2016 at 2:43 am
The textual explanation of the answer is right.
The actual answer set to be right is wrong.
May 6, 2016 at 3:31 am
taz.higgins (5/6/2016)
The textual explanation of the answer is right.The actual answer set to be right is wrong.
yeah exactly.:-)
Viewing 15 posts - 1 through 15 (of 60 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy