h1

Tipul de data BLOB si tipul BIT in mssql

March 15, 2010

Blob Data Type

Pt.a stoca date binare de orice tip ca fisier ASCII text, fisiere executabile (.exe) sau stream de biti cu o lungime nedeterminata se foloseste tipul de data BLOB (BLOB – acronim de la Binary Large Object).

Este util si pt.stocarea imaginilor in mssql.
Putem asigna valori la un camp blob folosind constante binare.
Exemple:

0h202020

0h6ABCDEF

0h (empty binary literal)

Binary literals are limited to 255 encoded bytes.

Tutorial complet aici despre BLOB:

http://msdn.microsoft.com/en-us/library/0t1k839z(VS.80).aspx

Tipul BIT este similar tipului de data boolean din limbajul PASCAL.

http://msdn.microsoft.com/en-us/library/ms177603.aspx

Tutorial tipuri de date mssql:

http://msdn.microsoft.com/en-us/library/ms177603.aspx

(data and field types)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: