Don't Understand Error Message (Database)

  • Thread starter Thread starter Jonathan Wood
  • Start date Start date
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.
 
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").





Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
 
In a way, yes. <g> But, logically, strings are different, as are
floating-point values.
 
Jonathan Wood said:
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.
Click to expand...

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.
Click to expand...


I know what you sad, but you did not make sense, it is not a numeric
question, there is only 2 answers, not 256
 
Jonathan Wood said:
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.
Click to expand...


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