Page 1 of 1

ORA-12704: character set mismatch

Posted: Thu 13 Feb 2014 23:46
by timothystewart6
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

Re: ORA-12704: character set mismatch

Posted: Fri 14 Feb 2014 12:35
by MariiaI
We have contacted you by e-mail.

Re: ORA-12704: character set mismatch

Posted: Tue 18 Feb 2014 09:55
by tiago
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.

Re: ORA-12704: character set mismatch

Posted: Tue 18 Feb 2014 14:17
by MariiaI
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.

Re: ORA-12704: character set mismatch

Posted: Wed 26 Feb 2014 14:48
by joezen777
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;

Re: ORA-12704: character set mismatch

Posted: Thu 27 Feb 2014 09:33
by Shalex
Thank you for your feedback.

Re: ORA-12704: character set mismatch

Posted: Thu 27 Feb 2014 12:48
by tiago
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.