Skip Menu |

This queue is for tickets about the DBI CPAN distribution.

Report information
The Basics
Id: 83763
Status: rejected
Priority: 0/
Queue: DBI

People
Owner: Nobody in particular
Requestors: avinashyelsangi [...] gmail.com
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



Hi Team, We are using DBI module in one of our product. Following is the sample code : #!/usr/bin/perl use strict; use DBI; my $dbh = DBI->connect("dbi:oracle:npm", "username", "password"); #my $name = "Anand"; my $name = "ranù.it1"; my $sth = $dbh->prepare("SELECT * FROM tablename WHERE name = ?"); $sth->bind_param(1, $name); $sth->execute(); my ($name, $address) = $sth->fetchrow(); print "$name $address \n"; $sth->finish(); $dbh->disconnect(); We are able to retrieve the values from tablename for name Anand (ascii character). But we are not able to retrieve the values from tablename for name "ranù.it1" (non-ascii character). Name "ranù.it1" exists in tablename . Please help us know how to resolve this issue. We are using below software and version for development: DBI version : 1.605 Perl Version : 5.8.8 Oracle version : 10.2.0.5 bash-3.00# locale LANG= LC_CTYPE=en_CA.ISO8859-1 LC_NUMERIC=en_CA.ISO8859-1 LC_TIME=en_CA.ISO8859-1 LC_COLLATE=en_CA.ISO8859-1 LC_MONETARY=en_CA.ISO8859-1 LC_MESSAGES=C LC_ALL= bash-3.00# echo $LNS_LANG It will fail for every user which contains diacritical marks(ù). We are not doing any encoding/decoding. sql > select * from nls_database_parameters NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CHARACTERSET UTF8 NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT DD-MON-RR NLS_DATE_LANGUAGE AMERICAN NLS_SORT BINARY NLS_TIME_FORMAT HH.MI.SSXFF AM NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR NLS_DUAL_CURRENCY $ NLS_COMP BINARY NLS_LENGTH_SEMANTICS BYTE NLS_NCHAR_CONV_EXCP FALSE NLS_NCHAR_CHARACTERSET AL16UTF16 NLS_RDBMS_VERSION 10.2.0.5.0 sql > select * from nls_session_parameters; NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT DD-MON-RR NLS_DATE_LANGUAGE AMERICAN NLS_SORT BINARY NLS_TIME_FORMAT HH.MI.SSXFF AM NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR NLS_DUAL_CURRENCY $ NLS_COMP BINARY NLS_LENGTH_SEMANTICS BYTE NLS_NCHAR_CONV_EXCP FALSE sql > select * from nls_instance_parameters; NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_SORT NLS_DATE_LANGUAGE NLS_DATE_FORMAT NLS_CURRENCY NLS_NUMERIC_CHARACTERS NLS_ISO_CURRENCY NLS_CALENDAR NLS_TIME_FORMAT NLS_TIMESTAMP_FORMAT NLS_TIME_TZ_FORMAT NLS_TIMESTAMP_TZ_FORMAT NLS_DUAL_CURRENCY NLS_COMP NLS_LENGTH_SEMANTICS BYTE NLS_NCHAR_CONV_EXCP FALSE Thanks & Regards, Avinash
Subject: Re: [rt.cpan.org #83763]
Date: Tue, 5 Mar 2013 08:04:12 +0100
To: bug-DBI [...] rt.cpan.org
From: "H.Merijn Brand" <h.m.brand [...] xs4all.nl>
On Mon, 4 Mar 2013 23:39:17 -0500, "Avinash via RT" <bug-DBI@rt.cpan.org> wrote: Show quoted text
> We are using DBI module in one of our product
Why re-post to the DBI queue? I think you posted the same question, then *with* a subject line, not too long ago. That post got moved to the DBD::Oracle queue https://rt.cpan.org/Public/Bug/Display.html?id=83656 The fact that your client raises an issue over your lack of response is IMHO no reason to re-post the issue to the bug queue of a module that most likely is NOT the culprit. INSTEAD, find other resources to help you with your problem. Sites like PerlMonks 1) or mailing lists like DBI *users* 2) are way more likely to get you an answer (in considerable less time) than pushing your problem as a "bug" in here. I'll just close this ticket as rejected. Please do NOT answer to re-open. 1) http://www.perlmonks.org 2) http://lists.perl.org/list/dbi-users.html -- H.Merijn Brand http://tux.nl Perl Monger http://amsterdam.pm.org/ using perl5.00307 .. 5.17 porting perl5 on HP-UX, AIX, and openSUSE http://mirrors.develooper.com/hpux/ http://www.test-smoke.org/ http://qa.perl.org http://www.goldmark.org/jeff/stupid-disclaimers/
Duplicate of https://rt.cpan.org/Public/Bug/Display.html?id=83656 which was moved to the DBD::Oracle queue