String Types
Wed, 03/04/2009 - 20:02 | 
hdanzl
Syntax
|
| | | | | | | | |
CHARACTER [ ( length ) ] CHAR [ ( length ) ] NULLSTRING [ ( length ) ] SHORTSTRING [ ( length ) ] SINGLECHAR CHARACTER VARYING [ ( length ) ] CHAR VARYING [ ( length ) ] VARCHAR [ ( length ) ] |
|
| | | |
CHARACTER LARGE OBJECT [ ( length ) ] CHAR LARGE OBJECT [ ( length ) ] CLOB [ ( length ) ] TEXT [ ( length ) ] |
<national character string type> ::=
|
| | | | | | | | |
NATIONAL CHARACTER [ ( length ) ] NATIONAL CHAR [ ( length ) ] NCHAR [ ( length ) ] NSINGLECHAR NATIONAL CHARACTER VARYING [ ( length ) ] NATIONAL CHAR VARYING [ ( length ) ] NCHAR VARYING [ ( length ) ] NVARCHAR [ ( length ) ] |
|
| | |
NATIONAL CHARACTER LARGE OBJECT [ ( length ) ] NCHAR LARGE OBJECT [ ( length ) ] NCLOB [ ( length ) ] |
|
| | |
BINARY LARGE OBJECT [ ( length ) ] BLOB [ ( length ) ] IMAGE [ ( length ) ] |
Notes
| ♦ | NexusDB stores string data either in fixed or variable length, depending on the STORAGE attribute in the table definition. |
| ♦ | If the length argument is omitted, then a length of 1 is implicit. |
| ♦ | The large object types have a dynamic length in NexusDB, up to the maximum capacity. Specifying the length argument has no effect, and is only included for syntax compatibility with SQL:2003. |
| ♦ | The character string type defines a single-byte ANSI string. |
| ♦ | CHARACTER is a fixed-length character string type with a maximum length of 8192 characters. Values are padded with trailing spaces on data retrieval to fill the fixed length. |
| ♦ | CHAR is equivalent to CHARACTER. |
| ♦ | CHARACTER VARYING is a variable-length character string type with the same maximum length as CHARACTER. |
| ♦ | CHAR VARYING and VARCHAR are equivalent to CHARACTER VARYING. |
| ♦ | NULLSTRING is a NexusDB synonym for CHARACTER VARYING. |
| ♦ | SHORTSTRING is a NexusDB-specific variable-length character string type with a maximum length of 255 characters. |
| ♦ | SINGLECHAR is a NexusDB-specific type that defines a single 8-bit character. |
| ♦ | CHARACTER LARGE OBJECT is a large object character string type with a maximum capacity of 4GB. |
| ♦ | CHAR LARGE OBJECT and CLOB are equivalent to CHARACTER LARGE OBJECT. |
| ♦ | TEXT is a NexusDB synonym for CHARACTER LARGE OBJECT. |
| ♦ | The national character string type defines a double-byte Unicode string with implicit character set UTF16. |
| ♦ | NATIONAL CHARACTER is a fixed-length character string type with a maximum capacity of 32767 characters. Values are padded with trailing spaces on data retrieval to fill the fixed length. |
| ♦ | NATIONAL CHAR and NCHAR are equivalent to NATIONAL CHARACTER. |
| ♦ | NSINGLECHAR is a NexusDB-specific type that defines a single 16-bit character. |
| ♦ | NATIONAL CHARACTER VARYING is a variable-length character string type with the same maximum length as NATIONAL CHARACTER. |
| ♦ | NATIONAL CHAR VARYING and NCHAR VARYING are equivalent to NATIONAL CHARACTER VARYING. |
| ♦ | NVARCHAR is a NexusDB synonym for NATIONAL CHARACTER VARYING. |
| ♦ | NATIONAL CHARACTER LARGE OBJECT is a large object character string type with a maximum capacity of 4GB. |
| ♦ | NCHAR LARGE OBJECT and NCLOB are equivalent to NATIONAL CHARACTER LARGE OBJECT. |
| ♦ | BINARY LARGE OBJECT is a large object binary string type with a maximum capacity of 4GB. |
| ♦ | BLOB is equivalent to BINARY LARGE OBJECT. |
| ♦ | IMAGE is a NexusDB-specific large object binary string type with a maximum capacity of 4GB. |
| ♦ | Two character strings are comparable only if they use the same collation and compare flags. |
| ♦ | A character string is assignable to any character string site, including sites having a different character set, provided that data loss does not occur during the translation. An exception is raised if an assignment leads to truncation of the character string data. |
| ♦ | A binary string is only assignable to a binary string type. |
Conformance
|
SQL:2003 standard NexusDB extensions |
- - - - - - - - - - |
Core SQL Feature F421 "National character" Feature T041 "Basic LOB data type support" NULLSTRING SHORTSTRING SINGLECHAR TEXT NSINGLECHAR NVARCHAR IMAGE |
Tags:
Questions? Problems?
- Interested to buy but something put you off?
- Can't find what you're looking for?
- Have a suggestion?
Let us know. If you're having trouble contacting us, please check here.
Site Updates
- Dec 4 2024 - 1:53pm
- Dec 4 2024 - 1:48pm
- Nov 19 2024 - 1:04pm
- Oct 17 2024 - 10:27am
- Jul 24 2024 - 1:22pm