SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Acronym Trivia


Acronym Trivia

Author
Message
Chad Crawford
 Chad Crawford
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4217 Visits: 18732
Comments posted to this topic are about the item Acronym Trivia
Carlo Romagnano
Carlo Romagnano
SSCertifiable
SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)

Group: General Forum Members
Points: 7327 Visits: 3395
I hate UNICODE. It uses a lot memory uselessly. It brings applications to BAD performance. Angry

I run on tuttopodismo
Ron Kunce
Ron Kunce
SSC Eights!
SSC Eights! (804 reputation)SSC Eights! (804 reputation)SSC Eights! (804 reputation)SSC Eights! (804 reputation)SSC Eights! (804 reputation)SSC Eights! (804 reputation)SSC Eights! (804 reputation)SSC Eights! (804 reputation)

Group: General Forum Members
Points: 804 Visits: 496
Trick Question! 60% of respondents didn't answer uNicode because they are ignorant of the true meaning. Many of SQL ServerCentral.com own articles and forum posts directly refer to the 'N' prefix as meaning unicode.

Ron K.

"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." -- Martin Fowler
DPhillips-731960
DPhillips-731960
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1586 Visits: 801
I feel the question is not trick, just badly written, as it leaves meaning of question up to callous disregard for interpretation. Quoted from the highly current (2008) reference given for the response to the question:

"
SQL Server 2008 Books Online (December 2008)
nchar and nvarchar (Transact-SQL)

Character data types that are either fixed-length, nchar, or variable-length, nvarchar, Unicode data and use the UNICODE UCS-2 character set.

nchar [ ( n ) ]
Fixed-length Unicode character data of n characters. n must be a value from 1 through 4,000. The storage size is two times n bytes. The ISO synonyms for nchar are national char and national character.

nvarchar [ ( n | max ) ]
Variable-length Unicode character data. n can be a value from 1 through 4,000. max indicates that the maximum storage size is 2^31-1 bytes. The storage size, in bytes, is two times the number of characters entered + 2 bytes. The data entered can be 0 characters in length. The ISO synonyms for nvarchar are national char varying and national character varying.
"

Notice the first sentence in each definition with the period at the end of the sentence. In SQL Server, it means the data in this data type will be Unicoded. Since the terms nchar and nvarchar are SQL Server terms, and not ISO terms, moving that the "n" "stand"s for national is in my view just bad questioning. It may have been derived as a synonym when created, but it strictly indicates Unicoding of the data for SQL Server, regardless of the meaning of the synonym in ISO.

Of course one could argue that the term "nchar" as a whole means Unicode. However, I would counter that since the only difference between "char" and "nchar" is the "n", that defines the meaning, with the "char" portion defining merely the string type data being encoded, or in this case Unicoded.

I suppose one could also argue that the question did not explicitly call out "SQL Server". However, since the terms "nchar" and "nvarchar" are not ISO standards or synonyms, but SQL Server terms or data types, and this is primarily a SQL Server site, that the implication that SQL Server is inferred, and not some other system, is nearly by rote. Even if it was another DBMS, it is still not an ISO term.

(Grin). Yes, I am a little put out that I get a "wrong answer" for choosing Unicode, and I admit that my response here is heavily tongue-in-cheekiness (albeit very correct!).
Anipaul
Anipaul
SSCrazy Eights
SSCrazy Eights (9.6K reputation)SSCrazy Eights (9.6K reputation)SSCrazy Eights (9.6K reputation)SSCrazy Eights (9.6K reputation)SSCrazy Eights (9.6K reputation)SSCrazy Eights (9.6K reputation)SSCrazy Eights (9.6K reputation)SSCrazy Eights (9.6K reputation)

Group: General Forum Members
Points: 9557 Visits: 1407
Wonderful question ...Smile



Ralf Dietrich
Ralf Dietrich
SSC-Addicted
SSC-Addicted (417 reputation)SSC-Addicted (417 reputation)SSC-Addicted (417 reputation)SSC-Addicted (417 reputation)SSC-Addicted (417 reputation)SSC-Addicted (417 reputation)SSC-Addicted (417 reputation)SSC-Addicted (417 reputation)

Group: General Forum Members
Points: 417 Visits: 87
very good question and another example to know the basics.
THe (really good) excerpt about BOL shows again, that sometimes "older" knowledge is better knowledge.

Look in new courses/books and you see mostly new features but only seldom "old" basics
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search