1 year ago
#316432
Pato
national characters in Oracle
we are using Oracle 19c there are setting in nls_database_parameters
nls_nchar_characterset is UTF8 nls_charchterset is WE8ISO8859P15
I have a table with one column of varchar2 and another column of nvarchar2
I try to insert in both column the same letter,non english ,for example ş and it is not wotking but if I try another non english letter in my language like ž then is is working in both columns. Another colleagues of mine can not insert any letter correctly using the same database user. I don't understand this behavior,what defines what you can insert as national character?
we receive a big list of different cities in different languages. What is the best way to insert all of them correctly?
oracle
char
oracle19c
nvarchar
0 Answers
Your Answer