How to do accent insensitive queries?

[rodrigo-rafael]

Hi!

First of all, congratulations and thanks for your job!

I read that node-firebase connections are always utf-8.

So, would you guys clarify me in this matter?

Best regards, Rodrigo Rafael

[rodrigo-rafael]

Hi, I forced collation my doing WHERE P.DESCRICAO COLLATE PT_BR LIKE '%plástico%'

But even so it is not working. The results are only those who contains 'á'

[joweste]

I have used domain to my columns as: CREATE DOMAIN NH_AVAL_ID_12 CHAR( 12 ) COLLATE WIN_PTBR

It works well.