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.4

Editions: Professional, Evaluation, Express