• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 276
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

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