The very small and the very large

Couple of questions:

There isn't a boolean data type. Currently I have it set up as a tinyint. Is there a better way of handling this or is tinyint the way to go?

Also I want to use a blob data type to store Word Documents that can be anywhere up to 100KiloBytes in size. However none of the datatypes will allow me to use beyond 8000bytes. However I have seen by searching that you can get past that if you run a various scripts. However I am not that techie and just want a ticky-box to do the same job. Is there a ticky-box in SQL Server Enterprise Manager to do this?

Thanks, Graham Reeds

I use tinyint for boolean, I got in the habit with older versions of sql server that didn't support a null in a bit field (so tri-state checkboxes didn't work). I believe newer sql versions allow nulls in a bit field, and that would be the desired datatype for boolean data.

The sql server text and image datatypes support blob storage. I don't know what scripts you are thinking about.

I will stick with tinyint for boolean.



I found some scripts in the MS SQL Server Resource Kit (available on the MSDN website) that would allow you to go past the 8000 byte limit. However I don't want to create a script that will allow me to do that, I want to load my data into a blob. At the firm that I previously worked for we loaded 15kb images into blobs and never had to run a script to allow that. I simply want to load 50-100kb Word documents into the database. They aren't going to be accessed that frequently so speed isn't that important.

Is there an easy way of going past the 8000byte limit?