erm... >.> Checkboxes... >.>

[mtairhead]

Hey all,

I'm moving from the World of Access to SQL. It's terrifying. I don't suppose you all could provide some hints...

I'm designing a system with a SQL back-end, and an HTML front end. I'm putting the SQL tables together right now... <dumb question>What data type would a checkbox be?</dumb question> In Access, I always chose "YES/NO" to create True/False fields.

Do I use a TinyInt datatype? When I make the connection in Front Page, how will SQL store that? 1s and 0s?

Thanks...

Andrew

 

[FoFa]

I usually make it a BIT value, only two values are 0 and 1.

 

[mtairhead]

Thanks!

....I'll risk another potentially ignorant question...

Why can I set the length of a column in SQL Server Enterprise Manager to, say "10" but be able to type many more characters than 10? Or, I recently set the length of a column, whose data type was "char", to "20" but was only allowed to type 10 characters when I opened the table.

Andrew

 

[mtairhead]

Never mind... I think.

Well, in any case, it's been corrected. I changed the value from "char" to "varchar" ....

Thanks,

Andrew