Informix Odbc Driver Error 21005
(troubleshooting) Problem(Abstract) Error -21005 selecting data from an IDS engine using ODBC. Symptom Problem when connecting to IDS Engine using ODBC. Cause The most common reason for this error is having character outside the codeset specified in the database. The environment variable DB_LOCALE is used to specify the database locale. When a database is created, the codeset used is defined by this variable, which means that only characters included in that particular codeset would be allowed. The default value for DB_LOCALE is en_US.8859-1. This locale value corresponds to "English" language, "US" territory and "8859-1" codeset. The 8859-1 codeset has a limited number of characters, some symbols like the Euro or single quotation mark are not allowed (other codeset like CP1252 or UNICODE do allow these symbols) If the client machine uses a different codeset than the one used in the database, a codeset conversion must be performed by the client communication libraries (GLS library) to correctly transform between the two codesets. An English Windows machine by default uses the 1252 codeset, which means a conversion would be needed. If at some point during this conversion the GLS libraries find a character that is not allowed in any of the two codesets it would fail with a GLS error. Since CSDK version 2.80, the ODBC driver is Unicode enabled, this means all the data the driver handles has to be in Unicode format. This means that a extra conversion has to be done: When retrieving data from the database the conversion is as follows: Codeset in DB_LOCALE -> Unicode -> Codeset in CLIENT_LOCALE When inserting data: Codeset in CLIENT_LOCALE -> Unicode -> Codeset in DB_LOCALE Error -21005 would appear when doing a select if there was an error in conversion. If for some reason the database contains characters outside the allowed ran
von GoogleAnmeldenAusgeblendete FelderNach Gruppen oder Nachrichten suchen
This question is answered. Helpful answers available: 2. Correct answers available: 1. Reply to this Thread Search Forum Back to Thread List Replies: 2 - Last Post: Oct 8, 2016 1:34 PM Last https://forums.embarcadero.com/message.jspa?messageID=693986 Post By: Hernando Duque Hernando Duque Posts: 31 Registered: 10/22/00 DXE6 FDac Informix system error -21005 Reply Posted: Mar 20, 2015 1:04 PM Hi to all, I im doing a select to a table that has a BLOB text field but it happens that if the BLOB field has non ASCII characters, the application hangs with this error: [FireDAC][Phys][ODBC][Informix ODBC Driver]Unspecified System Error informix odbc = -21005. If the BLOB field has ASCII chars then it runs fine. Any help will be appreciated. Regards, Hernando. Lajos Juhasz Posts: 505 Registered: 3/14/14 Re: DXE6 FDac Informix system error -21005 Reply Posted: Mar 23, 2015 1:54 PM in response to: Hernando Duque Hernando Duque wrote: Hi to all, I im doing a select to a table that has informix odbc driver a BLOB text field but it happens that if the BLOB field has non ASCII characters, the application hangs with this error: [FireDAC][Phys][ODBC][Informix ODBC Driver]Unspecified System Error = -21005. If the BLOB field has ASCII chars then it runs fine. Any help will be appreciated. Regards, Hernando. The error code -21005 means: Inexact character conversion during translation. One or more characters were translated using a substitution character. Translation in the reverse direction would not produce the original string. Make sure that the values of the CLIENT_LOCALE and DB_LOCALE environment variables are compatible. Check out for client and server locale. I never got this error message. Hernando Duque Posts: 31 Registered: 10/22/00 Re: DXE6 FDac Informix system error -21005 Reply Posted: Oct 8, 2016 1:34 PM in response to: Lajos Juhasz Just closing this thead Back to Thread List Legend Helpful Answer (5 pts) Correct Answer (10 pts) Server Response from: ETNAJIVE02 Copyright© 1994 - 2013 Embarcadero Technologies, Inc. All rights reserved. Developer Tools Blackfish SQL C++Builder Delphi FireMonkey Prism InterBase JBuilder J Optimizer HTML5 Builder 3rdRail & TurboRuby Dat