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.

问题评论:

原文地址:

https://stackoverflow.com/questions/47755437/r-obbc-query-diacritical-signs-in-database

Tags:, ,

添加评论

友情链接:蝴蝶教程