Re: Control storage of Data

From: David Portas (REMOVE_BEFORE_REPLYING_dportas_at_acm.org)
Date: 07/16/04


Date: Fri, 16 Jul 2004 13:46:31 +0100


> there seems to be a
> difference in how SQL Server and Oracle stores the data
> binary (?).

That's not so surprising. Oracle supports non-Wintel platforms which have
different standards for binary numerics. Probably Oracle's internal
implementation changes depending on the platform but maybe there are some
things they have standardised across all OSs - I really don't know.

To answer your question, in SQL Server there is no method of controlling how
values are stored internally beyond using the standard datatypes.

Lumigent (www.lumigent.com) markets a Log Explorer product so it may help
you to check it out if you haven't already. Maybe it will help you analyze
the log data.

Hope this helps.

-- 
David Portas
SQL Server MVP
--


Relevant Pages

  • Re: Why will we never see anything even remotely resembling decent standards compliance in SQL Serve
    ... > it is a considerable undertaking to cram in all the features that would ... *Anyone* who writes any code for SQL Server should demand standars compliance ... SQL Server already uses such mechanisms to govern code-breaking standards ...
    (microsoft.public.sqlserver.server)
  • Re: Persisting ADO as XML - almost convinced im crazy!
    ... bah, stupid non standards ... lol .. ... all hail .NET ... > Columnist, SQL Server Professional ...
    (microsoft.public.vb.database.ado)
  • Re: datetime month question
    ... Learn to write code to Standards; it will save you and the ... poor bastards that have to maintain code a lot of problems. ... totally different way than SQL Server, ... MySQL has a dialect convention that zeros in the month or ...
    (microsoft.public.sqlserver.programming)
  • SQL Server Standards Documentation
    ... The purpose of this document is to outline SQL Server standards and best ... Hardware / Operating System Configurations 3 ... Enterprise Edition Installation Screenshots 12 ...
    (microsoft.public.sqlserver.server)