Jump to main content
Product Documentation
Customer Support
HCL Informix V14.10
HCL Informix®
V
14.10
documentation
Product overview
Installing
Administering
Migrating and upgrading
Client APIs and tools
Embedding
Informix®
Extending
Informix®
Data warehousing
Designing databases
JSON compatibility
Security
SQL programming
Troubleshooting
Informix®
Informix PDF guides
Search
Home
Client APIs and tools
You can use the
HCL Informix®
implementation of client APIs to develop applications for
Informix®
database servers.
GLS User's Guide
The
Informix® GLS User's Guide
describes the Global Language Support (GLS) feature available in
Informix®
products.
SQL features
These topics explain how the GLS feature affects the
Informix®
implementation of SQL.
Character data types
The locale affects the collation of built-in SQL character data types.
Other character data types
The choice of locale can affect the character data types.
Client APIs and tools
You can use the
HCL Informix®
implementation of client APIs to develop applications for
Informix®
database servers.
Change Data Capture API Programmer's Guide
The
Informix® Change Data Capture API Programmer's Guide
describes how to program applications to process changed data from
HCL Informix®
databases using the
Informix® Change Data Capture API
.
Embedded SQLJ for
HCL Informix®
The
Informix® Embedded SQLJ User's Guide
contains information about using
Informix® Embedded SQLJ
.
ESQL/C Guide
The
Informix® ESQL/C Programmer's Manual
explains how to use
Informix® ESQL/C
, the
Informix®
implementation of Embedded Structured Query Language (SQL) for C (ESQL/C), to create client applications with database-management capabilities.
GLS User's Guide
The
Informix® GLS User's Guide
describes the Global Language Support (GLS) feature available in
Informix®
products.
GLS fundamentals
The Global Language Support (GLS) feature lets
Informix®
products handle different languages, cultural conventions, and code sets for Asian, African, European, Latin American, and Middle Eastern countries.
GLS environment variables
HCL Informix®
products establish the client, database, and server locales with information from GLS-related environment variables and from data that is stored in the database.
SQL features
These topics explain how the GLS feature affects the
Informix®
implementation of SQL.
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.
Character data types
The locale affects the collation of built-in SQL character data types.
Localized collation of character data
The choice of locale can affect the collating order of NCHAR and NVARCHAR character data types.
Other character data types
The choice of locale can affect the character data types.
The CHAR data type
The CHAR data type stores character data in a fixed-length field. Data can be a string of single-byte or multibyte letters, numbers, and other characters that are supported by the code set of your database locale.
The VARCHAR data type
The VARCHAR data type stores character strings of up to 255 bytes in a variable-length field. Data can consist of letters, numbers, and symbols. CHARACTER VARYING is handled the same as VARCHAR.
The LVARCHAR data type
The LVARCHAR data type can store character strings of up to 32,739 bytes in a variable-length field. If you specify no
maximum size
in its declaration, the default upper size limit is 2048 bytes. Data values can include letters, numbers, symbols, white space, and unprintable characters.
The TEXT data type
The TEXT data type stores any text data. TEXT columns typically store memos, manual chapters, business documents, program source files, and other types of textual information.
Handle character data
The GLS feature allows you to put non-ASCII characters (including multibyte characters) in the elements of an SQL statement.
Locale-sensitive data types
These topics explain how a locale affects the way that a database server handles the MONEY data type, extended data types, and smart large objects (CLOB and BLOB data types).
Data manipulation statements
The choice of a locale can affect certain SQL data manipulation statements.
Data definition statements
HCL Informix®
supports a configuration parameter, SQL_LOGICAL_CHAR, whose setting can simplify the use of certain Data Definition Language (DDL) statements of SQL when you declare character data types in locales that support multibyte code sets.
Database server features
These topics describe how the GLS feature affects the database server.
General SQL API features (ESQL/C)
These topics explain how the GLS feature affects applications that you develop with the
Informix® Client Software Development Kit
.
Informix® ESQL/C
features
These topics explain how the GLS feature affects
Informix® ESQL/C
, an SQL application programming interface (API).
Appendix
This section contains additional reference information.
API
The
Informix® GLS API Programmer's Guide
describes the global language support (GLS) application programming interface (API) available in
Informix® ESQL/C
and
HCL Informix®
DataBlade®
modules.
Informix® Object Interface for C++
Guide
The
Informix® Object Interface for C++ Programmer's Guide
describes how to develop
HCL Informix®
client applications by using the object-oriented C++ programming language.
Informix®
ODBC Driver Guide
The
Informix® ODBC Driver Programmer's Manual
serves as a user guide and reference for
Informix® ODBC Driver
, which is the
Informix®
implementation of the Microsoft™ Open Database Connectivity (ODBC) interface, Version
3.0
.
.NET provider options
The
Data Server
Provider for .NET
DB2®
provider option is the preferred
Informix®
provider for developing new applications.
Informix®
JDBC Driver Guide
The
Informix® JDBC Driver Programmer's Guide
describes how to install, load, and use
Informix® JDBC Driver
to connect to the
Informix®
database from within a Java™ application or applet.
Informix International Language Supplement (ILS) User Guide
These topics include information about the translated user interface files for Informix® UNIX™ products, locales, and code set conversion tables
Informix®
OLE DB Provider Guide
The
Informix® OLE DB Provider Programmer's Guide
describes the software requirements for using
Informix® OLE DB Provider
, show how to install and configure the provider for your use, and explain how to use
Informix®
OLE DB Provider to enable client applications, such as ActiveX Data Object (ADO) applications and web pages, to access data on the
Informix®
server.
Other character data types
The choice of locale can affect the character data types.
The CHAR data type
The CHAR data type stores character data in a fixed-length field. Data can be a string of single-byte or multibyte letters, numbers, and other characters that are supported by the code set of your database locale.
The VARCHAR data type
The VARCHAR data type stores character strings of up to 255 bytes in a variable-length field. Data can consist of letters, numbers, and symbols. CHARACTER VARYING is handled the same as VARCHAR.
The LVARCHAR data type
The LVARCHAR data type can store character strings of up to 32,739 bytes in a variable-length field. If you specify no
maximum size
in its declaration, the default upper size limit is 2048 bytes. Data values can include letters, numbers, symbols, white space, and unprintable characters.
The TEXT data type
The TEXT data type stores any text data. TEXT columns typically store memos, manual chapters, business documents, program source files, and other types of textual information.
Rate this topic
5 stars
4 stars
3 stars
2 stars
1 star
Comment on this topic.
By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at
https://hcltechsw.com/resources/us-government-contact
. Do not include any personal data in this Comment box.