Import PostgreSQL Values to QT

[raphaelf]

Hello everybody,

I have a PostreSQL Database. I am able to import values to a listView for example.
My problem is:
I have in a table a value like this: "lächerlich" .
I get in my listview l[]cherlich

How could i get the exactly value on qt?

QSqlQuery select("select language1, plural, language2, description from words_tbl order by language1");
	while(select.next())
	{
		QString language1 = select.value(0).toString();
...

QSqlQuery select("select language1, plural, language2, description from words_tbl order by language1");
	while(select.next())
	{
		QString language1 = select.value(0).toString();
...

To copy to clipboard, switch view to plain text mode 

Thanks

[wysota]

You have to use a proper text codec either in the database or in your app (or both).

[raphaelf]

Hallo Wysota,

Under Postre i am using text datatype and on qt QString..

Where could i found a example for my problem?
I dont have understand exactly how to implement this..

[wysota]

www.postgresql.org probably... You have to be aware which encoding the database uses and use the same to fetch data into QString.

[jacek]

Qt talks to the PostgreSQL in Unicode, so it should work out of the box. How did you fill the database with data?

[wysota]

Qt talks to the PostgreSQL in Unicode, so it should work out of the box.

Unless the database doesn't contain data in Unicode (or at least in the encoding specified by the database).

[raphaelf]

Hi everybody,

If i write a value direct on PGAdmin i can see extrange values on QT, but if i fill the database on QT it works fine..

My idea is to fill data from qt, so thats ok..

Thank you all

[wysota]

It probably means the database contents uses a different encoding than declared in the database.

[zlatko]

Try check client_encoding in postgresql.conf