TechTalk Genome v4.2

String Type Modifiers

Corresponding CLR Types

string, NullableString, SqlString, OracleString

Corresponding Microsoft SQL Server Types

char, nchar, varchar, nvarchar, text, ntext, xml (MSSQL 2005 only)

Corresponding Oracle Types

char, nchar, varchar2, nvarchar2, clob, nclob

Modifiers

Attribute Name Possible Values Default Value Description
Unicode true, false Depends on the string encoding specified for the schema in <StringEncoding> element . Specifies if the encoding of the value is Unicode. The Unicode setting generates nvarchar, nchar and ntext types instead of varchar, char and text in Microsoft SQL Server.
For Oracle database platforms, the Unicode setting generates nvarchar2, nchar and nclob types instead of varchar, char and clob.
Length positive integer, Infinite 255 Specifies the maximum number of characters that can be represented by the type. Specifying Infinite generates a BLOB database type (text or ntext in Microsoft SQL Server and clob or nclob in Oracle).
VariableLength true, false true Specifies if the database type uses a fixed or variable-length storage model. Fixed length string types fill out the end of the value with spaces up to the length specified in Microsoft SQL Server. This setting has no effect when the Length attribute is set to Infinite. The variable length setting generates varchar and nvarchar instead of char and nchar in Microsoft SQL Server and varchar2 and nvarchar2 in Oracle.
Blob true, false true (false for SQL Server 2008) On SQL Server 2008, specifies whether the (n)varchar(max) (false) or the (n)text (true) data type should be used. It has no effect for other database providers.
SqlXml true, false false Specifies if the xml data type is used. Can be used only for SQL Server 2005 or later. Specifying it as a sub-element, the document or content storage model (isDocument attribute) and the XML schema (xmlSchemaCollection attribute) can also be specified.

Requirements

Type: TechTalk.Genome.Schema.Builder.Xml.UnicodeXmlData, TechTalk.Genome.Schema.Builder.Xml.LengthXmlData, TechTalk.Genome.Schema.Builder.Xml.VariableLengthXmlData

Assembly: TechTalk.Genome.dll

Version: 4.2.11

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 | <StringEncoding> Element | Data types in OQL