Inconsistent return value types about crystal-mysql HOT 2 CLOSED

The type returned of each value is determined by the database engine. At least that is true in this driver.

There is no built in conversion from the returned type to an expected type.

Something like the following might help to unify the result to an Int64 when needed. The driver could always define new custom types. Without new concepts like which types are numerics, the solution will always depend on know supported types by each driver.

value = db.sacalar(query)
value64 = 
  case value
    when Int64
      value
    when Int32
      value.to_i64
    when ...
      ... expr : Int64 ...
    else
      raise "Unsupported numeric scalar type"
    end

from crystal-mysql.

Gotcha, thanks for the tips.

from crystal-mysql.