Post reply

datatype

  • December 13, 2010 at 9:01 am

    #230716

    Hi all,

    Is bigint in sql server equivalent of number(22) in Oracle? We use bigint for number(15) but not sure about 22..

    Thanks

  • December 13, 2010 at 9:05 am

    #1261766

    Here's the bigint doc. You'd need to compare it to the Oracle documentation

    http://msdn.microsoft.com/en-us/library/ms187745.aspx

  • December 13, 2010 at 10:35 am

    #1261839

    Thanks

    I tried float(126) I get the below error...

    Column or parameter #12: Specified column precision 126 is greater than the maximum precision of 53.

    Is there an equivalent for float(126)? Also, is Image the equivalent of LONG datatype?

    Thanks again

  • December 13, 2010 at 10:43 am

    #1261846

    This has the rules on all the data types in SQL Server: http://msdn.microsoft.com/en-us/library/ms187752.aspx

    The Oracle float(126) is simply a 64-bit numeric data type, which would be the equivalent of float(53) in SQL Server. They both handle the same numeric range.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • December 13, 2010 at 10:45 am

    #1261849

    "Image" is an obsolete binary data type. Use varbinary(max) instead. "Long" in Oracle appears to be a deprecated nvarchar data type comparable to nvarchar(max) in SQL Server. Would have been ntext in SQL 2000, not "image".

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply