ORA-12704: character set mismatch

ORA-12704: character set mismatch

Postby 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
timothystewart6
 
Posts: 1
Joined: Thu 13 Feb 2014 23:42

Re: ORA-12704: character set mismatch

Postby MariiaI » Fri 14 Feb 2014 12:35

We have contacted you by e-mail.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: ORA-12704: character set mismatch

Postby 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.
tiago
 
Posts: 2
Joined: Tue 18 Feb 2014 09:42

Re: ORA-12704: character set mismatch

Postby 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.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: ORA-12704: character set mismatch

Postby 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;
joezen777
 
Posts: 3
Joined: Wed 26 Feb 2014 14:31

Re: ORA-12704: character set mismatch

Postby Shalex » Thu 27 Feb 2014 09:33

Thank you for your feedback.
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44

Re: ORA-12704: character set mismatch

Postby 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.
tiago
 
Posts: 2
Joined: Tue 18 Feb 2014 09:42


Return to dotConnect for Oracle