![]() ![]() Multibyte characters with NVARCHAR To store multibyte character data in an NVARCHAR column, your database locale must support a code set with these same multibyte characters.Handle NVARCHAR data Within a client application, always manipulate NVARCHAR data in the CLIENT_LOCALE of the client application.The only difference between NVARCHAR and VARCHAR data types is the collation order, except in databases that were created with the NLSCASE INSENSITIVE property. Collate NVARCHAR data The NVARCHAR data type is a locale-sensitive data type.Data can be a string of single-byte or multibyte letters, digits, and other characters that are supported by the code set of your database locale. The NVARCHAR data type The NVARCHAR data type stores character data in a variable-length field.The NCHAR data type The NCHAR data type stores character data in a fixed-length field as a string of single-byte or multibyte letters, numbers, and other characters that are supported by the code set of your database locale.Localized collation of character data The choice of locale can affect the collating order of NCHAR and NVARCHAR character data types.Character data types The locale affects the collation of built-in SQL character data types.Name database objects You must declare names for new database objects (and in some cases, for storage objects, such as dbspaces) when you use data definition language (DDL) statements such as CREATE TABLE, CREATE INDEX, and RENAME COLUMN.SQL features These topics explain how the GLS feature affects the HCL® OneDB® implementation of SQL.GLS environment variables HCL OneDB™ products establish the client, database, and server locales with information from GLS-related environment variables and from data that is stored in the database.GLS fundamentals The Global Language Support (GLS) feature lets HCL® OneDB® products handle different languages, cultural conventions, and code sets for Asian, African, European, Latin American, and Middle Eastern countries.The HCL OneDB™ GLS User's Guide describes the Global Language Support (GLS) feature available in HCL® OneDB® products. GLS User's Guide These topics describe the Global Language Support (GLS) feature available in HCL® OneDB® products.ESQL/C Guide The HCL OneDB™ ESQL/C Programmer's Manual explains how to use, the HCL OneDB™ implementation of Embedded Structured Query Language (SQL) for C (ESQL/C), to create client applications with database-management capabilities. ![]() The HCL OneDB™ Change Data Capture API Programmer's Guide describes how to program applications to process changed data from HCL OneDB™ databases using the HCL® OneDB® Change Data Capture API. Change Data Capture API Programmer's Guide These topics describe how to program applications to process changed data from HCL OneDB™ databases using the HCL® OneDB® Change Data Capture API.Client APIs and tools You can use the HCL OneDB™ implementation of client APIs to develop applications for HCL OneDB™ database servers. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |