logo

abstract const class

sql::Dialect

sys::Obj
  sql::Dialect

Dialect encapsulates database specific behaviors for common database functions.

Slots

auto

virtual Str auto()

Get the db specific qualifier for a column whose value is automatically incremented for a new row. Default throws SqlErr.

getBlobType

abstract Str getBlobType(Int maxLen)

Get the database specific blob type for a blob with the specified maximum length.

getClobType

abstract Str getClobType(Int maxLen)

Get the database specific clob type for a clob with the specified maximum length.

maxIndexNameLength

abstract Int maxIndexNameLength()

Get the maximum length for index names for the database type.

maxTableNameLength

abstract Int maxTableNameLength()

Get the maximum length for table names for the database type.

notNull

virtual Str notNull()

Get the db specific qualifier for a column whose value cannot be null. Default is "NOT NULL".

unique

virtual Str unique()

Get the db specific qualifier for a unique column. Default is "UNIQUE".