SqlTypes

Full name JSql.Storage.SqlTypes Assembly JSql Members 6

sql canonical data types: INT, DOUBLE, VARCHAR, DATE, DATETIME, BOOLEAN

01 Syntax

JSql.Storage.SqlTypes

02 Methods

Name	Overloads	Summary
NormalizeType	1	normalize a mysql type name into one of the canonical type names.
CoerceValue	1	coerce a raw runtime value into the target canonical sql type.
CompareValues	1	compare two non-null scalar values.
IsNumericType	1
FormatDate	1
IsNumericValue	1

03 Members

method NormalizeType #

NormalizeType(String)

normalize a mysql type name into one of the canonical type names.

method CoerceValue #

CoerceValue(Object, String)

coerce a raw runtime value into the target canonical sql type.

method CompareValues #

CompareValues(Object, Object)

compare two non-null scalar values. numeric values are promoted and compared numerically, everything else falls back to ordinal string comparison (which also sorts iso-format date strings correctly).

method IsNumericType #

IsNumericType(String)

method FormatDate #

FormatDate(DateTime, String)

method IsNumericValue #

IsNumericValue(Object)