Skip to main contentSkip to search
Powered by Zoomin Software. For more details please contactZoomin
Progress DocumentationProgress Documentation
Progress Documentation
  • Home
  • Home
  • EnglishČeštinaDeutsch (Germany)Español (Spain)ФранцузскийItaliano (Italy)Português (Brasil)日本語Русский (Russia)中文 (简体) (China)中文 (繁體, 台灣) (Taiwan)ar-AR
  • Login

Progress DataDirect for ODBC Drivers Reference March 2026

Unicode and non-Unicode ODBC drivers

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
Table of Contents
  • Welcome to the Progress DataDirect for ODBC Drivers Reference
    • What is ODBC?
      • How does it work?
      • Why do application developers need ODBC?
  • Troubleshooting
    • Diagnostic tools
      • ODBC trace
        • Creating a trace Log
        • Enabling tracing
          • Windows ODBC Administrator
          • System information (odbc.ini) file
      • Configuration Manager Portal trace
      • Packet logging
      • Test loading tool
      • ODBC Test
      • Logging for Java components
        • Loggers and logging levels
          • Driver to SQL communication logger
          • SQL engine logger
          • Wire protocol adapter logger
        • Configuring logging
          • Using the JVM
          • Using the driver
      • The demoodbc Application
      • The example application
      • Enabling debug record mode
      • Other tools
    • Error messages
    • Troubleshooting issues
      • Setup/connection issues
        • Troubleshooting the issue
      • Interoperability issues
        • Troubleshooting the issue
      • Performance issues
  • Failover
    • Connection failover
    • Extended connection failover
    • Select connection failover
    • Guidelines for primary and alternate servers
    • Using client load balancing
    • Using connection retry
    • Summary of failover-related options
      • A connection string example
      • An odbc.ini file example
  • Client information
    • How databases store client information
    • Storing client information
  • Code page values
    • IANAAppCodePage values
    • IBM to IANA code page values
    • Teradata code page values
  • ODBC API and scalar functions
    • API functions
    • Scalar functions
      • String functions
      • Numeric functions
      • Date and time functions
      • System functions
  • Internationalization, localization, and Unicode
    • Internationalization and Localization
      • Locale
      • Language
      • Country
      • Variant
    • Unicode character encoding
      • Background
      • Unicode support in databases
      • Unicode support in ODBC
    • Unicode and non-Unicode ODBC drivers
      • Function calls
        • Unicode application with a non-Unicode driver
        • Unicode application with a Unicode driver
      • Data
        • Unicode driver
        • ANSI driver
      • Default Unicode mapping
        • Connection attribute for Unicode
    • Driver Manager and Unicode encoding on UNIX/Linux
      • References
    • Character encoding in the odbc.ini and odbcinst.ini files
  • Designing ODBC applications for performance optimization
    • Using catalog functions
      • Caching information to minimize the use of catalog functions
      • Avoiding search patterns
      • Using a dummy query to determine table characteristics
    • Retrieving data
      • Retrieving long data
      • Reducing the size of data retrieved
      • Using bound columns
      • Using SQLExtendedFetch instead of SQLFetch
      • Choosing the right data type
    • Selecting ODBC functions
      • Using SQLPrepare/SQLExecute and SQLExecDirect
      • Using arrays of parameters
      • Using the cursor library
    • Managing connections and updates
      • Managing connections
      • Managing commits in transactions
      • Choosing the right transaction model
      • Using positioned updates and deletes
      • Using SQLSpecialColumns
  • Security best practices for ODBC applications
    • Secure connection option settings
    • Protect data buffered to disk
    • Encrypt transferred data
    • Secure your driver configuration
    • Use advanced authentication methods
    • Protect against SQL injection attacks
    • Use HTTP proxies
    • Secure log files
    • Security considerations for the SQL engine server
  • Using indexes
    • Introduction
    • Improving row selection performance
    • Indexing multiple fields
    • Deciding which indexes to create
    • Improving join performance
  • Locking and isolation levels
    • Locking
    • Isolation levels
    • Locking modes and levels
  • SSL encryption cipher suites
  • DataDirect Bulk Load
    • DataDirect Bulk Load functions
    • Utility functions
      • GetBulkDiagRec and GetBulkDiagRecW
    • Export, validate, and load functions
      • ExportTableToFile and ExportTableToFileW
      • ValidateTableFromFile and ValidateTableFromFileW
      • LoadTableFromFile and LoadTableFromFileW
      • Using the TableName parameter with the Salesforce driver
      • SetBulkOperation (Salesforce driver only)
      • GetBulkOperation (Salesforce driver only)
    • DataDirect Bulk Load statement attributes
      • SQL_BULK_EXPORT_PARAMS
      • SQL_BULK_EXPORT
  • DataDirect connection pooling
    • Creating a connection pool
    • Adding connections to a pool
    • Removing connections from a pool
    • Handling dead connections in a pool
    • Connection pool statistics
    • Summary of pooling-related options
  • Threading
  • WorkAround options
  • Copyright
Table of Contents

Unicode and non-Unicode ODBC drivers

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: August 19, 2019
  • 1 minute read
    • DataDirect Connectors
    • ODBC
    • Aha! 8.0
    • Amazon Redshift 8.0
    • Apache Cassandra 8.0
    • Apache Hive 8.0
    • Apache Spark SQL 8.0
    • Autonomous Rest Connector 8.0
    • Cloudera Impala 7.1
    • dBase 7.1
    • + 24
      • Flat files/Text 7.1
      • GitHub 8.0
      • Google Bigquery 8.0
      • HubSpot 8.0
      • IBM Db2 8.0
      • IBM Informix Wire Protocol 8.0
      • Microsoft Dynamics 365 8.0
      • Microsoft SharePoint 8.0
      • Microsoft SQL Server 8.0
      • MongoDB 8.0
      • MySQL 8.0
      • MySQL 7.1
      • Oracle Database Wire Protocol 8.0
      • Oracle Service Cloud 7.1
      • Pervasive (Btrieve) 7.1
      • Greenplum 8.0
      • PostgreSQL 8.0
      • Progress Openedge 8.0
      • Salesforce 8.0
      • SAP S/4HANA 8.0
      • Snowflake 8.0
      • Teamcity 8.0
      • XML 7.1
      • Documentation

The way in which a driver handles function calls from a Unicode application determines whether it is considered a "Unicode driver."

Contents
  • Function calls
  • Data
  • Default Unicode mapping
TitleResults for “How to create a CRG?”Also Available inAlert