Solved

Has MS-SQL naitive support for Bytes fields?

Posted on 1998-06-01
4
231 Views
Last Modified: 2012-08-13
Hi,

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

With kind regards
 Christian Bøhn
0
Comment
Question by:chrb
  • 3
4 Comments
 
LVL 1

Accepted Solution

by:
JayMerritt earned 50 total points
ID: 1091412
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
 

Author Comment

by:chrb
ID: 1091413
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
 
LVL 1

Expert Comment

by:JayMerritt
ID: 1091414
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
 
LVL 1

Expert Comment

by:JayMerritt
ID: 1091415
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how the fundamental information of how to create a table.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now