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'
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'