Wrox Programmer Forums
|
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 9th, 2006, 04:14 AM
Authorized User
 
Join Date: Jun 2006
Posts: 88
Thanks: 0
Thanked 0 Times in 0 Posts
Default Sql servere datatype

Hi all

I have one byte array which i want to store in database.

which datatype is used to store byte array?

can u help me?

Thanks
monika

 
Old December 9th, 2006, 05:57 AM
Friend of Wrox
 
Join Date: Aug 2006
Posts: 231
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hello Monika
SQL Server have datatype "TinyInt" which takes one byte in memory
you can use it
Cheers



thanks......
 
Old December 14th, 2006, 03:11 PM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 385
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I am not sure I follow the question. The poster wants to store and "array" of one bite. If this is the case you can use the TinyInt with multiple rows to facilitate the array but I am not sure if this was the question? Does the poster want to store an array in a single field (single row)?






Similar Threads
Thread Thread Starter Forum Replies Last Post
Oracle to SQL Server DataType Mapping maulik33 SQL Language 0 November 1st, 2007 02:48 PM
datatype of sql MunishBhatia SQL Server 2005 4 January 5th, 2007 10:22 PM
SQL Text Datatype bekim ASP.NET 1.0 and 1.1 Professional 2 March 28th, 2006 12:05 AM
SQL Datatype rain_uk SQL Server ASP 2 July 5th, 2005 01:34 AM
sql datatype change be changed mateenmohd SQL Server 2000 3 July 18th, 2003 03:00 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.