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?
Unable to save data with "€" symbol in PostgreSQL DB
-
- Posts: 3
- Joined: Tue 12 Apr 2022 11:13
Re: Unable to save data with "€" symbol in PostgreSQL DB
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
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
-
- Posts: 3
- Joined: Tue 12 Apr 2022 11:13
Re: Unable to save data with "€" symbol in PostgreSQL DB
Hi,
This issue was solved by updating/setting "Unicode" value to "TRUE" before executing "ExecuteNonQuery()"
Thanks for reply.
This issue was solved by updating/setting "Unicode" value to "TRUE" before executing "ExecuteNonQuery()"
Thanks for reply.
Re: Unable to save data with "€" symbol in PostgreSQL DB
I also look forward to a tutorial heregolisomeshwar wrote: ↑Tue 12 Apr 2022 11:19 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?
word counter
Re: Unable to save data with "€" symbol in PostgreSQL DB
We would like to ask you to have a look at the following article https://blog.devart.com/oracle-to-postg ... ation.html