special character insertion issue with PostgreSQL database
Posted: Fri 01 Apr 2022 06:14
Hello all,
We are switching to Dot connect for PostgreSQL from another provider (Oracle). After switching to Dot Connect for PostgreSQL from oracle when we try to insert data (some special character), we can see the wrong data getting inserted in the table. example in Oracle we had one column with data ("PÖN") but in PostgreSQL same data is storing as("PÖN").
Now, we are curious about if there is a way to specify target data type for all specific data types. or is there any solution for this. or do we need to do some property changes for our PostgreSQL Db.
Regards
We are switching to Dot connect for PostgreSQL from another provider (Oracle). After switching to Dot Connect for PostgreSQL from oracle when we try to insert data (some special character), we can see the wrong data getting inserted in the table. example in Oracle we had one column with data ("PÖN") but in PostgreSQL same data is storing as("PÖN").
Now, we are curious about if there is a way to specify target data type for all specific data types. or is there any solution for this. or do we need to do some property changes for our PostgreSQL Db.
Regards