Ad Widget

Collapse

Infomation type - Unsigned vs float - Need example

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • registration_is_lame
    Senior Member
    • Nov 2007
    • 148

    #1

    Infomation type - Unsigned vs float - Need example

    Why is 484.89789 not a suitable as Decimal?
    Can someone give me example for a Numeric Unsigned decimal number vs Numeric Float? Just to make sense of it.

    perf_counter["\SQLServeratabases(_Total)\Transactions/sec"]" became not supported: Received value [484.89789] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
    Last edited by registration_is_lame; 21-08-2016, 06:31.
  • Atsushi
    Senior Member
    • Aug 2013
    • 2028

    #2
    Numeric(unsigned) is so unsigned integer, you can only save integer values.

    So if you want to save the value '484.89789', please try to select the Numeric(float).

    Comment

    Working...