Re: utf8 encoding problem

2006-12-22 Thread Peter J. Holzer
On 2006-12-21 16:17:53 +1000, Anand.K.S. wrote: Hello, I had posted this question in CPAN forum but i was directed here for a better answer. Here is the problem I am facing. In the following piece of code I get a customer name from the database and append a pound symbol to the customer

Re: utf8 encoding problem

2006-12-22 Thread Michael Kröll
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Peter J. Holzer wrote: $node_name = 'wre'; my $pound = \xc2\xa3; print Pound =$pound\n; That doesn't look like a pound sign in WE8DEC. You need to set NLS_LANG to the charset that you actually use, i.e., AMERICAN_AMERICA.UTF8 in your case. Or

Re: utf8 encoding problem

2006-12-22 Thread Peter J. Holzer
On 2006-12-22 10:11:57 +0100, Michael Kröll wrote: Peter J. Holzer wrote: $node_name = 'wre'; my $pound = \xc2\xa3; print Pound =$pound\n; That doesn't look like a pound sign in WE8DEC. You need to set NLS_LANG to the charset that you actually use, i.e., AMERICAN_AMERICA.UTF8 in your

Re: utf8 encoding problem

2006-12-21 Thread John Scoles
Unfortunety I cannot say for 100% sure this will solve you problem as there is no way to exactly match your system's setup. Oracle version/patches/Oracle client system enviornment etc. There were a large number of improvements in UTF encoding since 1.12 so my only sugestion is for you to

RE: utf8 encoding problem

2006-12-21 Thread Garrett, Philip \(MAN-Corporate\)
The easiest way to know is to try it out. If you want to just test it without replacing your installation's DBD::Oracle, you can do a temporary install of a newer version of DBD::Oracle by using the INSTALLSITELIB parameter to Makefile.PL: wget

Re: utf8 encoding problem

2006-12-21 Thread Anand . K . S .
Many thanks for your response. Client version - SQL*Plus: Release 10.2.0.1.0 - Production on Thu Dec 21 16:31:14 2006 Oracle version - Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi Cheers, Anand. On 12/21/06, John Scoles [EMAIL PROTECTED] wrote: Unfortunety I cannot say for