Problems with Unicode(UTF8)

[cristiano]

This is returned,

footest=# show client_encoding;
client_encoding
-----------------
SQL_ASCII
(1 registro)

footest=# select * from bairros;
id_bairro | id_cidade | nm_bairro | ch_repositorio
-----------+-----------+----------------+----------------
1 | 8105 | ESTREITO | S
2 | 8327 | PRAIA COMPRIDA | S
3 | 8105 | CENTRO | S
4 | 8105 | ATENÇÃO | S
(4 registros)

[jacek]

OK and what happens when you execute this?

footest=# set client_encoding to 'latin1';
footest=# select * from bairros;

[cristiano]

footest=# set client_encoding to 'latin1';
SET
footest=# select * from bairros;
id_bairro | id_cidade | nm_bairro | ch_repositorio
-----------+-----------+----------------+----------------
1 | 8105 | ESTREITO | S
2 | 8327 | PRAIA COMPRIDA | S
3 | 8105 | CENTRO | S
4 | 8105 | ATENÇÃO | S
(4 registros)

footest=# show client_encoding;
client_encoding
-----------------
latin1
(1 registro)

As 'latin1' the data is shown correctly, more in the continuous application with the incorrect characters.

[jacek]

Hmm... everything looks OK. Does the database protest if you issue:

SET client_encoding TO 'UNICODE';

?

[cristiano]

SET client_encoding TO 'UNICODE';
SET
footest=# select * from bairros;
id_bairro | id_cidade | nm_bairro | ch_repositorio
-----------+-----------+----------------+----------------
1 | 8105 | ESTREITO | S
2 | 8327 | PRAIA COMPRIDA | S
3 | 8105 | CENTRO | S
4 | 8105 | ATENO | S
(4 registros)

The data come incorrect, already I am losing the hope for this.

[jacek]

SET client_encoding TO 'UNICODE';
SET

OK, so IMO there shouldn't be any problem with the database.

What does this program output?

#include <QCoreApplication>
#include <QTextCodec>
 
#include <QtDebug>
 
int main( int argc, char ** argv )
{
   QCoreApplication app( argc, argv );
   qDebug() << QTextCodec::codecForLocale()->name();
}

#include <QCoreApplication>
#include <QTextCodec>

#include <QtDebug>

int main( int argc, char ** argv )
{
   QCoreApplication app( argc, argv );
   qDebug() << QTextCodec::codecForLocale()->name();
}

To copy to clipboard, switch view to plain text mode 

Do you use QString::fromUtf8(), QString::toUtf8() and similar methods in your program?
Do you use any static or global variables that have something to do with the database handling?

The data come incorrect

It doesn't matter, the most important part is that PostgreSQL wants to talk with you in Unicode.