byte[], SqlBinary, OracleLob, OracleBinary
binary,
varbinary,
image
raw,
long raw,
blob
| Attribute Name | Possible Values | Default Value | Description |
|---|---|---|---|
Length
|
positive integer, Infinite | Infinite | Specifies the maximum number of bytes that can be represented by the type. Specifying Infinite generates BLOB database types (image in Microsoft SQL Server, blob in Oracle) instead of binary or raw data types. |
VariableLength
|
true, false | true |
Specifies that the database type uses a fixed or variable-length storage model. This setting has no
effect if the Length attribute is set to Infinite. The variable length setting generates
varbinary instead of binary in Microsoft SQL Server. This setting has no effect on Oracle database platforms. |
Blob
|
true, false | true (false for SQL Server 2008) | On SQL Server 2008, specifies whether the varbinary(max) (false) or the binary (true) data type should be used. It has no effect for other database providers. |
Type: TechTalk.Genome.Schema.Builder.Xml.LengthXmlData, TechTalk.Genome.Schema.Builder.Xml.VariableLengthXmlData
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
Database Type Modifiers | Data types in OQL