You don't have a choice in SQL 2000. Only Image is a binary data type and as such is not affected by code page translations. In SQL 2005 you can use varbinary(MAX).
>I am tasked with creating a website (ASP.NET C#) to store and retrieve small (one page) XLS and PDF documents.
>This question deals with BLOB field design, not with .NET mechanics of input/output which are already covered.
>
>I have never dealt with SQL Server BLOBs. What would be the most efficient field type for these documents (they would be uploaded and encrypted before storing as BLOB):
>
>Considering the files are rather small, under 100K each and we'd have to save about 30 files per month. Being this small, with the specs I've been given it may not make much difference ion what type to save but you never know as spes are well known for not corresponding to reality a year from now when files/qty may start to grow :)
>
>Note: Saving the files on disk and just keeping a char pointer to it is not an option as the data has to be encrypted in the database so it is more secure/easier to manage as BLOBs.
>
>TIA
--sb--
