ORA-12704: character set mismatch

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
timothystewart6
Posts: 1
Joined: Thu 13 Feb 2014 23:42

ORA-12704: character set mismatch

Post by timothystewart6 » Thu 13 Feb 2014 23:46

Hi. We use dotConnect. We need to upgrade Devart. We use EF4 and Oracle. It seems like the SQL that is generated from Devart6 to Devart8 is different and throws en error.

Exception type: OracleException
Exception message: ORA-12704: character set mismatch
at Devart.Data.Oracle.a1.c(Int32 A_0)
at Devart.Data.Oracle.cs.d(Int32 A_0)
at Devart.Data.Oracle.cs.a(Int32 A_0, cc A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at Devart.Data.Oracle.Entity.f.a(CommandBehavior A_0)
at Devart.Common.Entity.cg.b(CommandBehavior A_0)
at Devart.Data.Oracle.Entity.f.b(CommandBehavior A_0)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)


We are using the latest (released today) - 8.2.100
We do not experience this with an older version - 6.30.185

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: ORA-12704: character set mismatch

Post by MariiaI » Fri 14 Feb 2014 12:35

We have contacted you by e-mail.

tiago
Posts: 2
Joined: Tue 18 Feb 2014 09:42

Re: ORA-12704: character set mismatch

Post by tiago » Tue 18 Feb 2014 09:55

Hello,

I downloaded the trial version of dotConnect 8.2 to use with EF6 and Oracle but I'm getting the error ORA-12704: character set mismatch, when the query includes null navigation properties.

My company is thinking on buying your provider but we need to be sure that it works with EF6 and Oracle.

Will this be fixed in a short time?

Thank you.

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: ORA-12704: character set mismatch

Post by MariiaI » Tue 18 Feb 2014 14:17

I downloaded the trial version of dotConnect 8.2 to use with EF6 and Oracle but I'm getting the error ORA-12704: character set mismatch, when the query includes null navigation properties.
Please send us a small test project with the corresponding DDL/DML script so that we can reproduce the issue in our environment. Please also specify the versions of your Oracle server and Oracle client.

joezen777
Posts: 3
Joined: Wed 26 Feb 2014 14:31

Re: ORA-12704: character set mismatch

Post by joezen777 » Wed 26 Feb 2014 14:48

I had to add this to my OnModelCreating to solve those problems.

Devart.Data.Oracle.Entity.Configuration.OracleEntityProviderConfig.Instance.CodeFirstOptions
.UseNonUnicodeStrings = true;
Devart.Data.Oracle.Entity.Configuration.OracleEntityProviderConfig.Instance.CodeFirstOptions
.UseNonLobStrings = true;

Shalex
Devart Team
Posts: 8084
Joined: Thu 14 Aug 2008 12:44

Re: ORA-12704: character set mismatch

Post by Shalex » Thu 27 Feb 2014 09:33

Thank you for your feedback.

tiago
Posts: 2
Joined: Tue 18 Feb 2014 09:42

Re: ORA-12704: character set mismatch

Post by tiago » Thu 27 Feb 2014 12:48

joezen777 thanks for the answer.

Mariial, sorry I didn't sent the test project but I wasn't sure if I could reproduce the problem outside of the company's environment.

Thank you all.

Post Reply