<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Pradyothana Shastry...
»
Basic
23 posts, Page 2 of 3
««
1
2
3
»»
Basic
Rate Topic
Display Mode
Topic Options
Author
Message
OCTom
OCTom
Posted Friday, August 06, 2010 6:22 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 10:06 AM
Points: 2,029,
Visits: 2,867
"The most commonly used character encoding on the World Wide Web was US-ASCII[9] until December 2007, when it was surpassed by UTF-8.[10][11][12]"
from http://en.wikipedia.org/wiki/ASCII
My gut told me the answer was going to be ASCII because it sounded like a Tech-100 beginners class question.
Post #965052
Richard M.
Richard M.
Posted Friday, August 06, 2010 6:55 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 10:37 AM
Points: 1,058,
Visits: 2,580
I always chuckle when Wikipedia is cited as a reference. Wkipedia, although a nice place to look up stuff (you basically find anything you are looking for), is not always a reliable source, in fact, it is prohibited to be used as a reference in colleges and some schools.
Not to say that the information provided is not correct. There's plenty of instances where you find proper source citation to make it perfectly valid and reliable.
This just reminds me of a
Dilbert strip
_______________________________________________________________________
For better assistance in answering your questions, click here
Post #965105
Tom Garth
Tom Garth
Posted Friday, August 06, 2010 7:39 AM
SSC Eights!
Group: General Forum Members
Last Login: Friday, February 04, 2011 7:20 AM
Points: 977,
Visits: 1,499
It's a valid answer and if there actually is supporting documentation for any of the answers, then someone please post it. I doubt that you will find it.
I knew the answer I was going to select before I saw the list, and I got a chuckle out of seeing BCD on the list.
Good Friday QotD. Thanks.
Tom Garth
Vertical Solutions
"There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
Post #965148
SQLRNNR
SQLRNNR
Posted Friday, August 06, 2010 8:29 AM
SSCoach
Group: General Forum Members
Last Login: Today @ 5:03 PM
Points: 18,853,
Visits: 12,438
Interesting question. Thanks
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #965202
Lynn Pettis
Lynn Pettis
Posted Friday, August 06, 2010 1:13 PM
SSC-Insane
Group: General Forum Members
Last Login: Today @ 1:13 PM
Points: 21,832,
Visits: 27,850
Richard M. (8/6/2010)
I always chuckle when Wikipedia is cited as a reference. Wkipedia, although a nice place to look up stuff (you basically find anything you are looking for), is not always a reliable source, in fact, it is prohibited to be used as a reference in colleges and some schools.
Not to say that the information provided is not correct. There's plenty of instances where you find proper source citation to make it perfectly valid and reliable.
This just reminds me of a
Dilbert strip
My daughters can't use Wikipedia as a source in their schools, but I tell them it can still be a starting point leading you to more reliable sources that can be used.
Lynn Pettis
For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here
or
when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here
and
here
Managing Transaction Logs
SQL Musings from the Desert
Fountain Valley SQL
(My Mirror Blog)
Post #965425
Richard M.
Richard M.
Posted Friday, August 06, 2010 2:19 PM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 10:37 AM
Points: 1,058,
Visits: 2,580
Lynn Pettis (8/6/2010)
Richard M. (8/6/2010)
I always chuckle when Wikipedia is cited as a reference. Wkipedia, although a nice place to look up stuff (you basically find anything you are looking for), is not always a reliable source, in fact, it is prohibited to be used as a reference in colleges and some schools.
Not to say that the information provided is not correct. There's plenty of instances where you find proper source citation to make it perfectly valid and reliable.
This just reminds me of a
Dilbert strip
My daughters can't use Wikipedia as a source in their schools, but I tell them it can still be a starting point leading you to more reliable sources that can be used.
Exactly my point. At least it can give you some idea on how to deepen the search and in some cases also following some sources is helpful ;)
_______________________________________________________________________
For better assistance in answering your questions, click here
Post #965459
Nadrek
Nadrek
Posted Monday, August 09, 2010 11:10 AM
Say Hey Kid
Group: General Forum Members
Last Login: Monday, June 10, 2013 1:08 PM
Points: 679,
Visits: 2,038
For anyone that says Unicode, I ask, which one?
UTF-8
UTF-16 (BE by default)
UTF-16BE
UTF-16LE
UTF-32 (BE by default)
UTF-32BE
UTF-32LE
Or, perhaps, late 90's (very archaic) implementations like UCS-2 (used in SQL Server as 'Unicode')?
Post #966125
honza.mf
honza.mf
Posted Monday, August 09, 2010 12:05 PM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, June 12, 2013 1:11 AM
Points: 1,114,
Visits: 1,209
Nadrek (8/9/2010)
For anyone that says Unicode, I ask, which one?
UTF-8
UTF-16 (BE by default)
UTF-16BE
UTF-16LE
UTF-32 (BE by default)
UTF-32BE
UTF-32LE
Or, perhaps, late 90's (very archaic) implementations like UCS-2 (used in SQL Server as 'Unicode')?
Does it matter?
For me UTF-16, any endian. Or any other, distinguished by BOM.
See, understand, learn, try, use efficient
© Dr.Plch
Post #966152
David Conn
David Conn
Posted Saturday, August 14, 2010 11:34 PM
SSCommitted
Group: General Forum Members
Last Login: Today @ 1:25 PM
Points: 1,705,
Visits: 674
Have only just got to this question.
My thoughts: How do you measure "Most Common" ?
Is it how may many Computers use it ? Probably ASCII because of the PC.
Is it how much Data is stored in the Format ? How do you measure the enormous amount of data on IBM Mainframes stored in EBCDIC ?
Is Unicode that Popular ? I usually avoid it where possible in favour of 8 bit ASCII.
Post #969450
Dietmar Weickert
Dietmar Weickert
Posted Sunday, August 22, 2010 2:34 PM
SSCommitted
Group: General Forum Members
Last Login: Friday, January 11, 2013 8:20 AM
Points: 1,608,
Visits: 373
Oh what a shortsighted question!
ASCII is a US only standard, hardly usable anywhere else. Ever thought about Europe? Do you really think the French, German, Scandinavian, Czech, Slovak, Slovene, Croatian, Polish, Baltic, Rumanian, Hungarian, Finish, Spanish, Portuguese people could do anything with their computers if they just used ASCII? And they have at least the Latin alphabet!
So what about the several hundred millions of people with Cyrillic alphabet? Do you really think they could use their computers if they had ASCII as the only foundation for coding their text data? And how about Asia? China probably outnumbers both all ASCII users and ASCII data volumes used anywhere in the world, and the Japanese numbers are amazing as well.
Both ASCII and EBCDIC are foundations for better systems at best. The first try was the ISO 8859 family of character sets; it still proofed to be insufficient. Meanwhile Unicode is there and becomes more and more mature. The fact that Microsoft (almost) fully supports Unicode in its modern Windows variants might make Unicode the character set used both by most users and for most data already. Of course you will find the 128 ASCII characters there as well - somewhere among the 100,000 others...
Best regards,
Dietmar Weickert.
Post #973109
« Prev Topic
|
Next Topic »
23 posts, Page 2 of 3
««
1
2
3
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
