Unicode provides a method of encoding national characters and symbols. The 8-bit character sets originally supported by ODBC limited character data to a maximum of 256 different characters.
Although many systems exist to extend this limit through the use of translator libraries and Code Pages, none of these are sufficient for character sets with more than 256 individual symbols or for applications needing to access different sets of national characters concurrently.
ODBC has provided "Wide" data types for some time, but until ODBC 3.51 there was no consistent Unicode interface. A Unicode ODBC driver enables all string input and output to be presented in Unicode, so not only can data be returned from a database in Unicode, but SQL queries may also be executed in Unicode.
While the ODBC version of Unicode provides for 16 bits per symbol, InterBase and Firebird use a more advanced encoding method called UTF-8, where the length of individual symbols may vary from 8 to 32 bits. Typically, an InterBase or Firebird database uses an extended character set, UNICODE_FSS being the full Unicode set.
The Easysoft ODBC driver transparently converts between these two formats, enabling Unicode-ready applications (such as Microsoft Access) to display and modify Unicode data in InterBase and Firebird databases. It can be said to be a Unicode ODBC driver.
© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.
