postgresqlasp.net-coreentity-framework-coreazure-database-postgresql
Azure database for postgreSQL Flexible Server and Entity Framework Core shows accented spanish words incorrectly
I have created a Flexible Server (Azure database for postgreSQL), I am using pgadmin to connect to this database (Encoding UTF8), I have a table named skills, and using pgadmin shows the spanish words correctly.
- SHOW SERVER_ENCODING; UTF8
- SHOW CLIENT_ENCODING; SQL_ASCII
The problem is when I connect entity framework core to this database, shows accented spanish words incorrectly, for example:
- Publicación (Correct)
- Publicaci\xf3n (Incorrect)
When I send data from Web API to database it is inserted this way
- Publicación
Solution
There is an option in Azure Database for PostgreSQL flexible server is Server Parameters,
Inside there is a parameter:
client_encoding was SQL_ASCII and I changed to UTF8
then my pgadmin shows accented spanish words correctly, that was the solution
- PostgreSQL: Modify OWNER on all tables simultaneously in PostgreSQL
- Postgresql autocomplete?
- SQL query to fetch persons with more than one postcode address via join table
- docker tmpfs seems to have no effect on postgresql
- ERROR: extra data after last expected column on postgresql
- Grouping rows by day in unixtime
- Select only distinct values from two tables on pgadmin without getting all combinations
- Performance loss introducing lateral join in Postgres query
- Is it possible to create a procedure with ANALYZE table instruction?
- Efficiently storing data that is partially columnar into a DuckDB database in a purely columnar form
- is there any way to write test cases for repositories in spring boot without using H2 daatabase?
- Error : relation "OutboxState" does not exist
- copying 3 columns from a 4 column table with multiple CONFLICT conditions
- Using pg_notify in PostgreSQL trigger function
- postgres: using previous row value when current row value is null
- EF Core one-to-one relation returns one-to-many relation
- Storing and managing Forex trading tick data
- Possible bug with PHP PDO and with PostgreSQL
- Error while loading shared libraries: libpq.so.5
- Duckdb sql and postgres results differ when using unnest
- How to connect to localhost with postgres_fdw?
- Python 3.10.6 alembic postgresql password with special character
- Using SQLAlchemy sessions with flask & concurrency problems
- How to reload PostgreSQL configuration
- How to show tables in PostgreSQL?
- How can I change a PostgreSQL user password?
- postgres- plsql function to get rows counts for specific columns with null data
- SQLAlchemy - Get query results in same order as IN clause
- Strange sorting behavior with bigint column via GiST index in PostgreSQL
- Laravel and PHP8.3 can't connect to Postgre database