Good afternoon, I have some problem how to insert special characters via procedure into the database.
I have a simple function that takes me through a purchase order, goes through the item numbers and adjusts the description accordingly. In the Czech description there is a character "č", which then gets me wrong in the database and I don't know where I am making a mistake.
and in IFS and database i see this
Thanks you guys
Best answer by SaaAvinak
Hello,
This could be due to the character set of your database not supporting this character.
you can check that using below SQL staement SELECT value FROM nls_database_parameters WHERE parameter = 'NLS_CHARACTERSET'; AL32UTF81 character set supports “č” and many more special characters.
Solution:
1: Change your character set. 2: Use Unicode characters like (UNISTR('\010D')) for “č”, but since you might be having many special characters, I would recommend the 1st solution.
This could be due to the character set of your database not supporting this character.
you can check that using below SQL staement SELECT value FROM nls_database_parameters WHERE parameter = 'NLS_CHARACTERSET'; AL32UTF81 character set supports “č” and many more special characters.
Solution:
1: Change your character set. 2: Use Unicode characters like (UNISTR('\010D')) for “č”, but since you might be having many special characters, I would recommend the 1st solution.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.