Re: MS Oracle Data Provider BUG: Data corrupt after 16 rows with O

From: Angel Saenz-Badillos[MS] (angelsa_at_online.microsoft.com)
Date: 07/19/04 

Date: Mon, 19 Jul 2004 15:50:30 -0700

I was thinking more along the lines of invalid UTF 8 data having been
inserted into the Oracle database. This is surprisingly easy to do and hard
to catch. By default some providers and sqlplus are not safe to use with
Unicode into a UTF8 database, when you insert Unicode data it inserts
"garbage". This is hard to catch because reading back the "garbage" data
with the same provider that you used to insert it will return the data you
where expecting. True Unicode providers like odp.net and the oracle managed
provider will instead return the "garbage". The best way to verify this is
to do a "select dump(<row>, 1016) from <yourtable>" and use a utf8
converter to verify that the data in the database is correct. 

-- 
Angel Saenz-Badillos [MS] Managed Providers
This posting is provided "AS IS", with no warranties, and confers no
rights.Please do not send email directly to this alias.
This alias is for newsgroup purposes only.
I am now blogging about ADO.NET: http://weblogs.asp.net/angelsb/
"Frans Bouma [C# MVP]" <perseus.usenetNOSPAM@xs4all.nl> wrote in message
news:xn0dkyszusv731000@msnews.microsoft.com...
> Angel Saenz-Badillos[MS] wrote:
>
> > It is really strange that both ODP.NET and the Oracle Client managed
> > provider are running into this question, especially since your database
is
> > using UTF8. How did you insert the data? Can you do a select dump to get
the
> > actual value inserted in the database and verify that the data was
inserted
> > correctly?
>
> ... perhaps it's something with the oracle client (thus not the provider,
> but the actual client software the provider talks to) settings.
>
> FB

Relevant Pages

  • Re: Cant get Oracle OLE DB provider to work from SSIS on a 64-bit environment
    ... The project I'm trying to get running, consists of approx 25 seperate packages where 3-4 of them gets data from different Oracle sources, but I'm not even got to the point where I'm trying to run the whole lot. ... There are two issues in the topic that could be an issue, and that is to switch the whole project to 32-bit mode and then the part that says that the Designer only shows 32-bit versions of the provider. ... What I think I'll try now, it to install the 32-bit version of the Oracle ODAC to see if that makes any difference. ... uninstall ODAC and when I uninstall the regular Oracle Client with the ...
    (microsoft.public.sqlserver.dts)
  • Re: Data Provider for Oracle: MS version vs. Oracle?
    ... Microsoft provider will work also for Oracle (even if the native ... Again this DAL works for SQLServer, Oracle, PostgreSQL, all DB2 (AS ... 400 and Universal), and other database are in preparation, I’m ... but that doesn't mean my int customerID ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: tnsnames not working. tnsping picks sqlnet.ora
    ... My oracle client has been working fine till today. ... I triend to tnsping the new database and any other old database and I ... configuration assistant) to add the entry again. ...
    (comp.databases.oracle.misc)
  • Re: Oracle Data Provider for .NET (ODP.NET)
    ... A 12154 is most often caused by a configuration error, ... > Provider for .NET 9.2.0.4.0 to access the database? ... > well known error when attempting to connect to the Oracle 8i database. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Apparent DBD::Oracle 1.16 unicode regression
    ... >> I suspect an oracle client version mismatch with the server. ... database, and from a 9.2 client to a 9.2 database. ... oracle client software or OLDER versions of oracle on the database side. ... Since you say this breaks _every_ one of your customers, however, I find ...
    (perl.dbi.users)