Post reply

What Type Of Field To Store A Blob In

  • February 2, 2006 at 9:05 am

    #152724

    Hi, I am creating a table to store an XML blob in.   I am wondering what would be the best data type to store it in. nText, Text, Image or nChar?  and what would be the differences.

     

    Thank

     

    e...

  • February 3, 2006 at 12:25 am

    #618579

    in sql2005 use the xml-datatype

    I just took a look at the way biztalk handles it, and they are using a mix of ntext and image in SQL2000.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • February 3, 2006 at 10:55 am

    #618746

    (SQL Server 2000)

    Since XML is just text, forget the image type. I'd probably use the text type.

    If you need to use Unicode characters, use one of 'n' types such as ntext or nvarchar, otherwise use text or varchar.

    Since Unicode characters take 2 bytes each, you get half the storage capacity. For example, the maximum nvarchar is nvarchar(4000), while the maximum varchar is varchar(8000).

     

  • February 14, 2006 at 11:55 am

    #620795

    Thanks guys.  Much appreciated. 🙂

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply