Hi

I have an xml message which have characters like this ( Ü ) in it. These
type of characters are part of a persons name. I am trying to send this name
to an oracle database but I get an error message which says
java.sql.SQLException: Cannot map Unicode to oracle character. The unicode
character looks like this on unix ( FOUCHM-oM-?M-= ).

I am using HPUX 11.11 and oracle 9i.

What do I need to do to send these characters to oracle database ?

Shaun

In article <d2gsrn$1neh$2@newsreader02.ops.uunet.co.za>,
shaun.lukhan@eskom.co.za wrote:
> Hi
>
> I have an xml message which have characters like this ( Ü ) in it. These
> type of characters are part of a persons name. I am trying to send this name
> to an oracle database but I get an error message which says
> java.sql.SQLException: Cannot map Unicode to oracle character. The unicode
> character looks like this on unix ( FOUCHM-oM-?M-= ).
>
> I am using HPUX 11.11 and oracle 9i.
>
> What do I need to do to send these characters to oracle database ?

You need to use a Unicode characterset (NLS_CHARACTER=UTF8) in your Oracle
database, I believe. This would be a better question for Oracle or an
Oracle-related newsgroup. I do not know what other changes are required for
your Oracle DB.

FYI - see this bug against sqlplus: 3919801. If you have any code that does
RPAD/LPAD, etc, it may not display correctly. We are just starting to use
Unicode and this has broken several scripts that query Oracle.

Kevin

--
Unix Guy Consulting, LLC
Unix and Linux Automation, Shell, Perl and CGI scripting
http://www.unix-guy.com