Many character sets and their corresponding collations are provided to support Paradox for DOS, Paradox for Windows, dBASE for DOS, and dBASE for Windows.

The following character sets correspond to MS-DOS code pages, and should be used to specify character sets for InterBase® databases that are accessed by Paradox for DOS and dBASE for DOS:

Character sets corresponding to DOS code pages

The names of collation orders for these character sets that are specific to Paradox begin “PDOX”. For example, the DOS865 character set for DOS code page 865 supports a Paradox collation order for Norwegian and Danish called “PDOX_NORDAN4”.

The names of collation orders for these character sets that are specific to dBASE begin “DB”. For example, the DOS437 character set for DOS code page 437 supports a dBASE collation order for Spanish called “DB_ESP437”.

For more information about DOS code pages, and Paradox and dBASE collation orders, see the appropriate Paradox and dBASE documentation and driver books.

There are five character sets that support Windows client applications, such as Paradox for Windows. These character sets are WIN1250, WIN1251, WIN1252, WIN1253, and WIN1254.

The names of collation orders for these character sets that are specific to Paradox for Windows begin “PXW”. For example, the WIN1252 character set supports a Paradox for Windows collation order for Norwegian and Danish called “PXW_NORDAN4”.

For more information about Windows character sets and Paradox for Windows collation orders, see the appropriate Paradox for Windows documentation and driver books.

Support for additional character sets and collation orders is constantly being added to InterBase®. To see if additional character sets and collations are available for a newly created database, connect to the database with isql, then use the following set of queries to generate a list of available character sets and collations:

SELECT RDB$CHARACTER_SET_NAME, RDB$CHARACTER_SET_ID
  FROM RDB$CHARACTER_SETS
  ORDER BY RDB$CHARACTER_SET_NAME;

SELECT RDB$COLLATION_NAME, RDB$CHARACTER_SET_ID
  FROM RDB$COLLATIONS
  ORDER BY RDB$COLLATION_NAME;

Source: InterBase® 2009 Language Reference Guide

Last updated 2010-02-23

Any comments? Send an email to register@ibexpert.biz

COPYRIGHT © 2002-2022 HK-Software, IBExpert Ltd. All rights reserved.

All IBExpert brand and product names are trademarks or registered trademarks of IBExpert Ltd in Malta and other countries.

InterBase, Delphi, CodeGear, C++Builder, Delphi/400, Delphi for PHP and JBuilder are trademarks or registered trademarks of Embarcadero Technologies Inc. in the United States and other countries. Firebird is a registered trademark of the FirebirdSQL Foundation.

Turbo Pascal is a registered trademark of Borland International, Inc. Sun, Java, JavaScript and Solaris are trademarks or registered trademarks of Sun Microsystems, Inc. or its subsidiaries in the United States and other countries. UNIX is a registered trademark in the United States and other countries, exclusively licensed through “The Open Group”.

Oracle is a registered trademark of Oracle Corporation in the United States and other countries. All Microsoft brand and product names are trademarks or registered trademarks of Microsoft Corporation in the United States and other countries.

AS/400, DB2, IBM, Informix and iSeries are trademarks or registered trademarks of IBM Corporation in the United States and other countries. Linux is a registered trademark of Linux Torvalds. dBASE is a trademark of dataBased Intelligence, Inc. Skype is a registered trademark of Skype Ltd., in the United States and other countries.

All other product names mentioned herein and throughout the entire web site are trademarks of their respective owners.