Error -21005 when using ODBC to select data from a database. Error -21005 selecting runtime error 1cv8.exe from an IDS engine using ODBC.
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. This locale value corresponds to “English” language, “US” territory and “8859-1” codeset. 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.