Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 274
  • Last Modified:

Has MS-SQL naitive support for Bytes fields?

Hi,

Has MS-SQL naitive support for Bytes fields? Or do I have to use BLOB instead?

With kind regards
 Christian Bøhn
0
chrb
Asked:
chrb
  • 3
1 Solution
 
JayMerrittCommented:
try tinyint:

Datatype      Description
      
SQLARRAY      1 byte with variable length
SQLBINARY      binary
SQLBIT      bit
SQLCHAR      char
SQLDATETIM4      4-byte smalldatetime
SQLDATETIME      8-byte datetime
SQLDATETIMN      datetime or smalldatetime with null values allowed
SQLDECIMAL      decimal
SQLFLT4      4-byte real
SQLFLT8      8-byte float
SQLFLTN      float or real with null values allowed
SQLIMAGE      image
SQLINT1      1-byte tinyint
SQLINT2      2-byte smallint
SQLINT4      4-byte int
SQLINTN      tinyint, smallint, or int with null values allowed
SQLMONEY4      4-byte smallmoney
SQLMONEY      8-byte money
SQLMONEYN      money or smallmoney with null values allowed
SQLNUMERIC      numeric
SQLTEXT      text
SQLVARBINARY      varbinary
SQLVARCHAR      varchar
0
 
chrbAuthor Commented:
Yes or No? With binary field I mean a field that is stored inside the main database not in a blob file. I havn't got MS-SQL, I was only interested to know. In Paradox og Flashfiler a fpBytes field is supported nativly which mean they are much faster to read/write than to blob fields.

So does it support it without using a blob file?
Yes/No

Chr
0
 
JayMerrittCommented:
In the initial question you said Byte field.

I responded with - use tinyint - which is a Byte field.

If you want to store pictures and such, use varbinary.
0
 
JayMerrittCommented:
In the initial question you said Byte field.

I responded with - use tinyint - which is a Byte field.

If you want to store pictures and such, use varbinary.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now