1 year ago

#316432

test-img

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

Accepted video resources