Borland®
Shop
Products Downloads Services Support Partners News & Events Company Community
Company

 SQL LINKS DEVELOPER SUPPORT

SEARCH Borland Online/Developer Support

Tech Notes Index


Subject:Foreign characters (e.g. äÄöÖ ) in Interbase

Foreign characters inserted into an Interbase table via 
Interbase Windows ISQL (WISQL) do not show up correctly 
in BDE applications.  The reverse is also true, foreign 
characters entered into an Interbase table via the BDE 
do not show up correctly in WISQL.

If a user attempts to change the language driver setting 
for the SQL Links driver or alias to something other than 
the default, an Interbase -802 error, "arithmetic exception, 
numeric overflow, or string truncation" occurs when the 
client application attempts to fetch a record containing 
these foreign characters.  The error detail also says 
"Cannot transliterate character between character sets".

Why?  The default installation of the BDE sets the System 
language driver to "Paradox 'ascii'".
This setting mainly controls how characters are stored and 
displayed.  Since Paradox tables can only handle the OEM 
character set (i.e. the ASCII character set supported in 
DOS) that's how the BDE was "mapping" the characters.

The solution is to change the the BDE's system language 
driver to something more appropriate, such as "'ascii' ANSI".


PUB
IB LINK CONFIG
SW


 
Site Map Search Contact