Home
Client APIs and toolsYou can use the HCL Informix® implementation of client APIs to develop applications for Informix® database servers.
Informix® OLE DB Provider GuideThe 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.
Troubleshooting installation, configuration, or operation problemsThis section describes how to resolve problems that you might encounter when installing, configuring, or using Informix® OLE DB Provider.
Nonalphabetic MBCS characters generate syntax errorsWhen you issue an SQL statement against an MBCS database (for example, SJIS-S), the HCL Informix® server returns a syntax error if the statement includes table or column names containing MBCS characters not classified as alphabetic in the locale.

Nonalphabetic MBCS characters generate syntax errors

When you issue an SQL statement against an MBCS database (for example, SJIS-S), the HCL Informix® server returns a syntax error if the statement includes table or column names containing MBCS characters not classified as alphabetic in the locale.

Possible cause

Identifiers that include nonalphabetic characters are not enclosed in quotation marks.

Resolution

Enclose identifiers in quotation marks, and make sure DELIMIDENT is set. If you have no control over the SQL produced by the application, consider using a locale that classifies the characters in question as alphabetic.

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.