EF6 + Postgresql - 22021: invalid byte Sequence for encoding "UTF8": 0xc9 0x52

Question

I am trying to get data from a Postgresql database with Enconding SQL_ASCII, but in some records I get error message "22021: invalid byte Sequence for encoding "UTF8": 0xc9 0x52"

I have tried to set the Enconding in the connection string in several ways, but without success, error occurs "Keyword not supported"

Does anyone know of a solution other than switching the bank’s Enconding to UTF8?

Answer 1

In version 3.1.8 support for ClientEncoding in the connection string, which solves many problems: I already answered this here: Accentuation problem in postgresql with npgsql

The solution is:

var sqlBuilder = new NpgsqlConnectionStringBuilder
                {
                    Host = strLocal,
                    Database = strNome,
                    Username = strUser,
                    Password = strSenha,
                    Pooling = false,
                    Encoding = "windows-1252",
                    ClientEncoding = "sql-ascii"
                };

 string strConexao = sqlBuilder.ConnectionString;

Version log: https://github.com/npgsql/npgsql/milestone/36?closed=1

Log da Issue: https://github.com/npgsql/npgsql/issues/392

Answer 2

Bad news. The Npgsql team gave up SQL_ASCII support.

Directly forcing the use of LATIN1 for strings, this user managed to use SQL_ASCII in his system. The problem is that this can hardly be used together with the Entity Framework, whose parameterization activity is automatic.

I see no alternative but to migrate the bank to UTF-8, which is highly recommended.

Answer 3

Staff had the same problem using a bank sql_ascii with version 8.3 of Postgres. I resolved using the version 4.0.7 of Npsql and adding the parameters below in the connection string:

Host=localhost;Port=5432;Database=lab_sis;Username=labsis_usr;Password=******;***ENCODING=LATIN1;client Encoding=LATIN1***