ORA-12704: character set mismatch

[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

[MariiaI]

We have contacted you by e-mail.

[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.

[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.

[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;

[Shalex]

Thank you for your feedback.

[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.