EntityFrameworkCore.FirebirdSQL icon indicating copy to clipboard operation
EntityFrameworkCore.FirebirdSQL copied to clipboard

FromSQL not working with Accents

Open halfs2 opened this issue 6 years ago • 0 comments

I'm doing raw sql queries with fromSQL () and everything works fine until I need to compare some string with accent, running select in dbeaver works, the same select in my program returns nothing. Does anyone know why? If I change the word to JEBAO and using select with JEBAO works, then it's really some problem with accentuation.

in database = 'JEBÃO' working on DBeaver, nothing working on my aplication select distinct pw.marca as Brand from produto_web pw where pw.marca = 'JEBÃO'

in database = 'JEBAO' working on DBeaver, working on my aplication select distinct pw.marca as Brand from produto_web pw where pw.marca = 'JEBAO'

halfs2 avatar Oct 03 '19 21:10 halfs2