National Character Data Types

National Character data types support a 16-bit character set, as opposed to the 8-bit ASCII character set supported by the other textual data types.

Omnidex supports NCHAR data types to the extent that the data contains only characters from the ASCII character set. This means that if Omnidex can convert it to an 8-bit character, it can be indexed, displayed and manipulated, just like a CHAR.

However, if the data contains characters not found in the ASCII character set, Omnidex support is limited to transport only. This means it can be stored in the database and retrieved and transported in its binary form by Omnidex to the application, but any attempt by Omnidex to translate or convert the data in any way, will result in an error.

In technical terms, this means the 8 high-order bits of the 16-bit National Character character must contain 0 (zeroes) in order for Omnidex to do anything other than transport the data in its binary form.

NCHAR

Space-padded data up to 32,767 characters.

NCHAR is the National Character (UNICODE) data type equivalent to CHAR or CHARACTER.

Support for National Character Data types is limited as described above.

COLUMN "CUSTOMERID" PHYSICAL "CustomerID" DATATYPE NCHAR(5)

NC STRING

Null-terminated data up to 64MB. See Text Indexing Length Variation for restrictions on the 64MB limit.

NC STRING is the National Character data type equivalent to C STRING.

Support for National Character Data types is limited as described above.

Because the National Character characters are 2 bytes each, twice the size of ASCII characters, the number of characters that can be contained within the 16MB extracted text limit is half that of the C STRING data type.

COLUMN "PHOTOPATH" PHYSICAL "PhotoPath" DATATYPE NC STRING(255)

NVARCHAR

Non-terminated and non-padded data up to 4095 bytes.

NVARCHAR is the National Character data type equivalent to VARCHAR.

Support for National Character Data types is limited as described above.

COLUMN "COMPANYNAME" PHYSICAL "CompanyName" DATATYPE NVARCHAR(40)

NCLOB

Non-terminated and non-padded data up to 64MB. See Text Indexing Length Variation for restrictions on the 64MB limit.

This data type may contain embedded null characters since it is not null-terminated; however, it should not be used to store binary data.

NCLOB is the National Character data type equivalent to CLOB.

Support for National Character Data types is limited as described above.

Because the National Character characters are 2 bytes each, twice the size of ASCII characters, the number of characters that can be contained within the 16MB extracted text limit is half that of the CLOB data type.

COLUMN "HOMEPAGE" PHYSICAL "HomePage" DATATYPE NCLOB(32767)

Top