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

Discussion of open issues, suggestions and bugs regarding database management and development tools for PostgreSQL
Post Reply
golisomeshwar
Posts: 3
Joined: Tue 12 Apr 2022 11:13

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

Post by golisomeshwar » 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?

dzhanhira
Devart Team
Posts: 182
Joined: Mon 26 Oct 2020 13:49

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

Post by dzhanhira » Thu 14 Apr 2022 10:55

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
Posts: 3
Joined: Tue 12 Apr 2022 11:13

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

Post by golisomeshwar » Tue 19 Apr 2022 10:36

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

pipahaha
Posts: 1
Joined: Tue 21 Jun 2022 01:57

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

Post by pipahaha » Tue 21 Jun 2022 02:03

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

dzhanhira
Devart Team
Posts: 182
Joined: Mon 26 Oct 2020 13:49

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

Post by dzhanhira » Wed 22 Jun 2022 07:41

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

Post Reply