Data Science & Machine Learning

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problems with latin character such as ñ, accents using ROracle

72ffe030-4018-43cf-8ff1-d474fd3730d1Apr 17 2018 — edited Apr 17 2018

Hi all, I have a problem that I could not solve. When I try to insert row with character such as ñ , in data base to insert -> UNILEVER ESPAÃ‘A,S.A.

I am using RStudio + ROracle + windows 10

set environment : Sys.setenv(NLS_LANG = "SPANISH_SPAIN.WE8ISO8859P1")

the data base have the properties : SELECT * FROM NLS_DATABASE_PARAMETERS

NLS_NCHAR_CHARACTERSET AL16UTF16

NLS_LANGUAGE SPANISH

NLS_TERRITORY SPAIN

NLS_CURRENCY ?

NLS_ISO_CURRENCY SPAIN

NLS_NUMERIC_CHARACTERS ,.

NLS_CHARACTERSET WE8ISO8859P1

NLS_CALENDAR GREGORIAN

NLS_DATE_FORMAT DD/MM/RR

NLS_DATE_LANGUAGE SPANISH

NLS_SORT SPANISH

NLS_TIME_FORMAT HH24:MI:SSXFF

NLS_TIMESTAMP_FORMAT DD/MM/RR HH24:MI:SSXFF

NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZR

NLS_TIMESTAMP_TZ_FORMAT DD/MM/RR HH24:MI:SSXFF TZR

NLS_DUAL_CURRENCY ?

NLS_COMP BINARY

NLS_LENGTH_SEMANTICS BYTE

NLS_NCHAR_CONV_EXCP FALSE

NLS_RDBMS_VERSION 11.2.0.4.0

Somebody could help me, please.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 15 2018

Added on Apr 17 2018

#r-technologies

0 comments

617 views