Re: Charset problems when connecting from cygwin

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 16 Mar 2007 06:25:56 +0100
Message-ID: <45fa2a64$0$22849$>

"Michael Zedeler" <> a écrit dans le message de news: Y1jKh.97$
| Hi everyone.
| I have written a perl script that tries to insert data into a table in
| an Oracle database residing on an aix server. Running the perl script on
| the server works fine, but if I try running it on my local machine
| (cygwin on Windows XP), I get this message:
| DBD::Oracle::st execute failed: ORA-06550: line 9, column 20:
| PLS-00553: character set name is not recognized
| The database uses DANISH_DENMARK.WE8MACROMAN8S, but I am completely at a
| loss wrt what to do to make perl/DBD::Oracle/the Oracle client library
| behave as it should.
| The data I try to insert into the database is from an ISO-8859-1 encoded
| file.
| I tried setting NLS_LANG to the same charset as the database claims it
| is using when I log on this gave me ORA-12705: Cannot access NLS data
| files or invalid environment specified. It seems that the client is
| trying to find some sort of conversion table that is unavailable.
| I am using the latest XE client.
| My question is: what kind of trickery on the client side do I need to
| make the script run in the environment described above?
| Regards,
| Michael.
| --
| Which is more dangerous? TV guided missiles or TV guided families?
| I am less likely to answer usenet postings by anonymous authors.
| Visit my home page at

What is your server Oracle version?
What is your client Oracle version?

Michel Cadot Received on Fri Mar 16 2007 - 06:25:56 CET

Original text of this message