Unable to save data with "€" symbol in PostgreSQL DB

[golisomeshwar]

Hi All,
As a part of DB migration we are moving from Oracle to PostgreSQL v11. During insertion we are unable to save the column data which all are having special characters like "€" or any other special character.
Our server encoding methodology is "UTF 8" and client encoding set to "UTF 8". Still facing the issue.
Can anyone suggest how to resolve the issue?

[dzhanhira]

Hi there,

Thanks for visiting our forum!

Could you please provide your INSERT? Also, clarify the steps and what result do you want to achieve?

Best regards,
Devart team
Dzhanhir

[golisomeshwar]

Hi,
This issue was solved by updating/setting "Unicode" value to "TRUE" before executing "ExecuteNonQuery()"
Thanks for reply.

[pipahaha]

Hi All,
As a part of DB migration we are moving from Oracle to PostgreSQL v11. During insertion we are unable to save the column data which all are having special characters like "€" or any other special character.
Our server encoding methodology is "UTF 8" and client encoding set to "UTF 8". Still facing the issue.
Can anyone suggest how to resolve the issue?

I also look forward to a tutorial here
word counter

[dzhanhira]

We would like to ask you to have a look at the following article https://blog.devart.com/oracle-to-postg ... ation.html