Solved

Has MS-SQL naitive support for Bytes fields?

Posted on 1998-06-01
4
240 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

825 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