R OBBC query – diacritical signs in database


I want to search my database by R ODBC query. Some names in database include diacritical sign and compilator has a problem to find them. For example word ‘główny’ can be found by typing ‘g\032ówny’.

What I tried to search is:

query1 = "select name, platform
from db
where platform = 'mobile' and name = 'główny'
group by name, platform"

I want to optain the result for name ‘główny’ but I have an error.
I tried to change language by Sys.setlocale("LC_CTYPE", "Polish"), but does not work.




Tags:, ,

Add a Comment