Is iSQL*Plus the only UTF8/Unicode enabled client we support?
On Windows OS, yes, On Unix OS’s, no. All the database utilties, including Import, Export, SQL*Loader, SQL*Plus, can act as a UTF-8 client if the OS locale is UTF-8 (e.g., en_US.UTF-8 on Linux) and NLS_LANG character set is set to UTF8 or AL32UTF8. How to check the code points managed by a UNIX Operating System? To know which code point is generated for a character in a Unix Environment, you can use the “od” command: $ echo “” | od -xc You can also check the character corresponding to a code point using the “echo” command like this: for Solaris, AIX, HP-UX, TRU64: $echo ‘\0351’ for Linux: $echo -e ‘\0351’ You can use Locale Builder or a printed code page (see links below) to verify that your native code page and NLS_LANG setting properly correspond. If there is any ambiguity then use the command above to get the values for more than one character. For printed code page: http://www.unicode.org http://www.iso.org http://czyborra.com/charsets/iso8859.
