comparision Int(64) vs binary(64)

• @puyinc

  Right there with Babe

  Points: 791

  More actions

  February 25, 2004 at 10:31 am

  #163143

  Hi,

  I am using SQL Server 2000 and Delphi 6 enterprise edition.

  In delphi I have a string of binary digits, I need to save it to the database and later on compare this number to another of the same data type.

  I was wondering what is faster, to store the number in binary or in longint and to compare two longint or two binary(64)?

  thanks in advance

  Kindest Regards,

  @puy Inc

• wz700

  SSCertifiable

  Points: 7133

  More actions

  February 25, 2004 at 3:19 pm

  #495704

  According to data storage length, bigint will be faster.