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.