Im using a non-ascii character set in my Oracle database, why am I get get garbage back when I do a select?
When the Oracle connection daemon fetches data from the database, the Oracle client library converts the data from whatever character set the database is using into whatever character set is specified by the NLS_LANG environment variable. If NLS_LANG isn’t set, is set to a character set that doesn’t contain some of the characters that are stored in the database, or is set to a character set that is in some other way incompatible with the character set of the database, some of the data will be converted into garbage. Note: NLS_LANG must be set properly on the machine running the SQL Relay servers, as that is the machine executing code from the Oracle client library. It’s not uncommon to forget to set NLS_LANG on that machine and then have things break suddenly when switching from using the Oracle client library directly to using SQL Relay. Note: When SQL Relay starts at boot time, the SQL Relay init script has no particular environment. So, if NLS_LANG is set in /etc/profile or /etc/bas
