TechTalk Genome v4.2

Decimal Type Modifiers

Corresponding CLR Types

decimal, NullableDecimal, SqlDecimal, OracleDecimal

Corresponding Microsoft SQL Server Types

decimal, numeric

Corresponding Oracle Types

number

Modifiers

Attribute Name Possible Values Default Value Description
Precision 1..38 38 Specifies the maximum number of decimal digits the database type can represent. For Microsoft SQL Server, decimal(precision, scale) is generated.
For Oracle database platforms, number(precision, scale) is generated.
Scale 0..precision 0 Specifies the place of the decimal point when representing a number (i.e. how many digits can stand to the right of the decimal point). The smallest number that can be represented is 1 / 10 scale in the database. For Microsoft SQL Server decimal(precision, scale) is generated.
For Oracle database platforms, number(precision, scale) is generated.

Requirements

Type: TechTalk.Genome.Schema.Builder.Xml.PrecisionXmlData, TechTalk.Genome.Schema.Builder.Xml.ScaleXmlData

Assembly: TechTalk.Genome.dll

Version: 4.2.4

Editions: Professional, Evaluation, Express

Database Platforms: Microsoft SQL Server 2000, Microsoft SQL Server 2005, Oracle 9i Release 2, Oracle 10g Release 2

See Also

Database Type Modifiers | Data types in OQL