ORA-12704: character set mismatch
Posted: 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
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