Page 1 of 1
Unable to save data with "€" symbol in PostgreSQL DB
Posted: Tue 12 Apr 2022 11:19
by 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?
Re: Unable to save data with "€" symbol in PostgreSQL DB
Posted: Thu 14 Apr 2022 10:55
by 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
Re: Unable to save data with "€" symbol in PostgreSQL DB
Posted: Tue 19 Apr 2022 10:36
by golisomeshwar
Hi,
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
Posted: Tue 21 Jun 2022 02:03
by pipahaha
golisomeshwar 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?
I also look forward to a tutorial here
word counter
Re: Unable to save data with "€" symbol in PostgreSQL DB
Posted: Wed 22 Jun 2022 07:41
by dzhanhira
We would like to ask you to have a look at the following article
https://blog.devart.com/oracle-to-postg ... ation.html