Solved

Has MS-SQL naitive support for Bytes fields?

Posted on 1998-06-01
4
258 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
I have a large data set and a SSIS package. How can I load this file in multi threading?
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.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

737 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