Don't Understand Error Message (Database)

[Mark Rae [MVP]]

After programming for 30 years, I'm sure you are well aware that a byte is
an integer type. In the context of 32 and 64-bit integers, I would
consider an 8-bit type to be a small one. Don't you agree?

http://technet.microsoft.com/en-us/library/ms187745.aspx

 

[Jonathan Wood]

I wasn't referring to specific SQL data type names, if that's what this is
about. I was talking in general terms about using a small integer.

 

[Juan T. Llibre]

Wow! Why did I have to login to Password to see that page ?

To make things a bit clearer, a byte doesn't equal a smallint,
but a tinyint...at least in SQL Server.

In VB.NET, an integer equals 32 bits (VB6's "Long").

 

[Jonathan Wood]

In a way, yes. <g> But, logically, strings are different, as are
floating-point values.

 

[ThatsIT.net.au]

ThatsIT.net.au,


Because that is the smallest integer possible. And it also happens to be
the smallest field size as well.


It would be 1 bit field. That's 8 bits. It's not the same as 1/8th of a
byte.


In fact, I could have up to 8 with the same storage. Big deal. With an
integer value stored in a byte, I could have up to 256 different values.

There is only 2 genders not 256

I already explained why using an integer was more straight forward. If you
got what I said, then you know the reason. If you didn't, then we're
probably just wasting time.

I know what you sad, but you did not make sense, it is not a numeric
question, there is only 2 answers, not 256

 

[ThatsIT.net.au]

Heh, well there ya go. The ISO standard for storing the sex would appear
to require a small integer. Oh well, I'm not looking to follow any ISO
standard, but looks like my approach is not unprecedented.

actually the question being asked for in the ISO example is asking a
different question with 4 possible results.

 

[ThatsIT.net.au]

Actually every thing in computers is a bit, as all binary is bits "y or n"
"1 or 0"