Home
Client APIs and toolsYou can use the HCL OneDB™ implementation of client APIs to develop applications for HCL OneDB™ database servers.
GLS User's GuideThese topics describe the Global Language Support (GLS) feature available in HCL® OneDB® products.The HCL OneDB™ GLS User's Guide describes the Global Language Support (GLS) feature available in HCL® OneDB® products.
General SQL API features (ESQL/C)These topics explain how the GLS feature affects applications that you develop with the HCL OneDB™ Client Software Development Kit.
Handle locale-specific dataEach HCL OneDB™ SQL API product contains a processor to process HCL OneDB™ ESQL/C source files that have embedded SQL and preprocessor statements.
Avoid partial charactersWhen you use a locale that supports a multibyte code set, make sure that you define buffers large enough to avoid the generation of partial characters.
Copy character dataWhen you copy data, you must ensure that the buffers are an adequate size to hold the data. If the destination buffer is not large enough for the multibyte data in the source buffer, the data might be truncated during the copy.

Copy character data

When you copy data, you must ensure that the buffers are an adequate size to hold the data. If the destination buffer is not large enough for the multibyte data in the source buffer, the data might be truncated during the copy.

For example, the following HCL OneDB™ ESQL/C code fragment copies the multibyte data A1A2A3B1B2B3 from buf1 to buf2:

char buf1[20], buf2[5];
...
stcopy("A¹A²A³B¹B²B³", buf1);
...
stcopy(buf1, buf2);

Because buf2 is not large enough to hold the multibyte string, the copy truncates the string to A1A2A3B1B2. To prevent this situation, ensure that the multibyte string fits into a buffer before the HCL OneDB ESQL/C program performs the copy.