problems getting Hebrew strings from Oracle
- From: sagivba@xxxxxxxxx (Sagiv Barhoom)
- Date: Fri, 28 Apr 2006 18:27:51 +0300
Hi all,
I have 2 machines: linux_perl_machine and sql_server (Oracle 9i).
I am trying to connect from the perl machine to the sql_server and execute :
"select Hebrew from Hebrew_Table" ,
but all I get is somthing like: '???? ??????'
The perl machine is not local and I work on it via ssh.
The db encoding is logical and the linux_perl_machine is:
LANG=he_IL.UTF-8
LC_CTYPE=he_IL.UTF-8
LC_NUMERIC=he_IL.UTF-8
LC_TIME=en_GB.UTF-8
LC_COLLATE=he_IL.UTF-8
LC_MONETARY=he_IL.UTF-8
LC_MESSAGES=he_IL.UTF-8
LC_PAPER=he_IL.UTF-8
LC_NAME=he_IL.UTF-8
LC_ADDRESS=he_IL.UTF-8
LC_TELEPHONE=he_IL.UTF-8
LC_MEASUREMENT=he_IL.UTF-8
LC_IDENTIFICATION=he_IL.UTF-8
LC_ALL=
any ideas?
--
Blue Skies Cler Air
Sagiv
- Prev by Date: Re: Checking if a table exist
- Next by Date: RE: problems getting Hebrew strings from Oracle
- Previous by thread: problem connecting to DB2 in perl using DBI
- Next by thread: RE: problems getting Hebrew strings from Oracle
- Index(es):