What does binary data mean & what are Unicode strings?

RON

Binary data is raw, unadulterated, unfiltered data.  An example of binary
data is a graphic JPEG or MPG file, as opposed to a text file which would be
roughly equivalent to CHAR or VARCHAR data.

Unicode is a system of representing CHAR or VARCHAR textual data.  Just like
ASCII is one way to represent textual data, Unicode also assigns numbers to
textual letters.  The difference being that ASCII covers basically the Latin
alphabet, while Unicode attempts to include every alphabet in the world.
Unicode takes up twice as much space as most standard Latin alphabet
representations (like ASCII).

For more info on Unicode, look up NCHAR and NVARCHAR in BOL.

http://www.unicode.org/


<r***@rediffmail.com> wrote in message
Show quoteHide quote

We do not care about the PHYSICAL representation of data in RDBMS.

This is like sayimg. "Okay, the earth is round, but what append when
we sail off the edge?"

Please read a book before you post again.

BIT(n) and BIT VARYING(n)?

"We might be sailing off the edge of the world later, but we still have to
decide whether we're going to make oars out of wood or papier mache."

Show quoteHide quote

Berating newbies is a really despicable way to increase your royalties
revenue.

and the RDBMS model  <<
Show quoteHide quote

Brian, that was the most appropriate response to Celko's comments.
There are a handful of people like Celko out there whose only job is to
pass such obnoxious remarks. Do they get paid for it?

Thanks to you & to Michael as well but not to Celko :-)

RON

Query problem
Pros/Cons using sqltransaction class vs stored procedure
Can I avoid using a cursor
DECLARE CURSOR ON EXEC... (Sybase does it, so why cant SQL Server?
Aaron, Itzik - about the MIN Function