Re: Control storage of Data

From: J. Persson (jpn_1966_at_yahoo.dk)
Date: 07/16/04 

Date: Fri, 16 Jul 2004 02:52:45 -0700

Hi

Thank you for your reply.

I am aware of the facts your writing about, so I might
have to be a bit more specific.

My co-worker is writing an application that reads "raw
binary data" information directly from the SQL Server
transaction log file using MFC C++ (not "through the
tables" presented to us "normal database people" when we
use T-SQL, ADO.NET etc.).

Since my company plans to extend our application so it can
handle Oracle databases also, they have discovered (that's
what they have told me anyway) that there seems to be a
difference in how SQL Server and Oracle stores the data
binary (?). They think it may have a conection to how a
decimal value is stored when the value is btw. 1 and -1
(eg. does the binary pattern represent 0.5 or .5).

I hope this makes more sence.

yours truly

jakob Persson

>-----Original Message-----
>Numeric data isn't *stored* in that format at all. It's
stored internally as
>a binary number.
>
>What you really want is to control the way it is
displayed and entered on
>the screen. How to control that formatting depends on
your client
>application or development platform not on SQL Server.
Regional Settings are
>usually determined by your Windows Control Panel settings.
>
>--
>David Portas
>SQL Server MVP
>--
>
>
>.
>

Relevant Pages

  • Re: SQL Server 2000 speed problems
    ... SQL Server MVP ... > CREATE TABLE Control ... > Every second the database gets updated with a timestamp and 50 new values. ... ' Perform the actual writing to the database through the batch of SQL ...
    (microsoft.public.sqlserver.programming)
  • SQL Server 2000 speed problems
    ... The first one is a control table with 2 ... Every second the database gets updated with a timestamp and 50 new values. ... written to the database, and the writing needs to be fast, in the region of ... And I don't quite understand it, because I thought that SQL Server ...
    (microsoft.public.sqlserver.programming)
  • Re: Control storage of Data
    ... Numeric data isn't *stored* in that format at all. ... What you really want is to control the way it is displayed and entered on ... application or development platform not on SQL Server. ... usually determined by your Windows Control Panel settings. ...
    (microsoft.public.sqlserver.server)
  • Re: Re: hey, go believe a bankruptcy
    ... As completely as Haji offsets, you can control the writing much more ... If the rich proceeds can position somewhat, ...
    (sci.crypt)
  • Re: vb.net dataTbl can DTS read?
    ... then using ADO to read/write the data to Sql Server. ... like what DTS does with Text Files, MS Access data, etc. ... Right now I am experimenting with writing the data from ...
    (microsoft.public.sqlserver.dts)