CODEWITHSUNDEEP
rrodbc
omzeybek
omzeybek

Reputation: 315

Missing Foreign string characters in sqlExecute() queries

we needed to fetch data from our database to R directly, we employed sqlExecute(). However, because our string columns contain escape letters such as “ş”, “ö”, “ğ” (Turkish characters which don’t exist in US-Char codes), these characters left missing in my query outputs. Do you know any arguments for sqlExecute() to solve this problem?

Upvotes: 1

Views: 22

Answers (1)

IRTFM
IRTFM

Reputation: 263342

You need to set your R locales at the very least and possible set your system locale to allow the use of valid codes and fonts. Since you have provided none of the details of your system and applications, specific advice is not possible. Read ?locales which does say that setting this in R should be honored by your system facilities but that exceptions have been observed.

Here's further information from: https://docs.moodle.org/dev/Table_of_locales

cat(hdr)
package_name    lang_name   locale  localewin   localewincharset
> cat(trk)
tr_utf8 Turkish tr_TR.UTF-8 Turkish_Turkey.1254 WINDOWS-1254

Upvotes: 2

Related Questions