c# - Entity Framework 6.1.3 and Oracle produces sql with Unicode on NonUnicode column -
i'm using entity framework 6.1.3 oracle manageddataaccess 12.1.022 , oracle.manageddataaccess.entityframework 12.1.022 (nuget packages)(fig 1). project database first , imports model .edmx file running t4 code. fig 1. the database uses varchar2 columns , .edmx file recognizes them nonunicode. (fig 2 & 3) fig 2. fig 3. when running query, oracle error ora-12704: character set mismatch . query: var emp2 = db.employees .where(s => s.first_nm.toupper().startswith(term.toupper()) || s.last_nm.toupper().startswith(term.toupper())) .select(c => new { label = c.first_nm + " " + c.last_nm, value = c.first_nm + " " + c.last_nm }); using .totracestring() can see sql being sent is: select 1 "c1", ((((case when ("extent1"."first_nm" null) n'' /* unicode here null value */ else "extent1...