sql select with unicode

[stevocz]

Hi.

how can i select data from postgresql with unicode character?

in sql admin work this two select:

SELECT st_astext(way) FROM planet_osm_roads WHERE boundary='administrative' AND admin_level='2' AND name='საქართვ ელო';

SELECT st_astext(way) FROM planet_osm_roads WHERE boundary='administrative' AND admin_level='2' AND name=U&'\10e1\10d0\10e5\10d0\10e0\10d7\10d5\10d4\1 0da\10dd';


but when i try this select in my qt c++ program nothing send back


sql database is in UTF8



EDIT: this work:

QString test= QString::fromUtf8 ("საქართვრ”ლო");
query.prepare("SELECT st_astext(way) FROM planet_osm_roads WHERE boundary='administrative' AND admin_level='2' AND name='"+ test +"';");

[ChrisW67]

Your first option will only work if you tell Qt it is UTF-8 encoded (assuming it is):

QSqlQuery qry(QString::fromUtf8("SELECT st_astext(way) FROM planet_osm_roads WHERE boundary='administrative' AND admin_level='2' AND name='საქართველო' "));

QSqlQuery qry(QString::fromUtf8("SELECT st_astext(way) FROM planet_osm_roads WHERE boundary='administrative' AND admin_level='2' AND name='საქართველო' "));

To copy to clipboard, switch view to plain text mode 

Your second option will only work if you escape the backslashes correctly for a C++ string:

QSqlQuery qry("SELECT st_astext(way) FROM planet_osm_roads WHERE boundary='administrative' AND admin_level='2' AND name=U&'\\10e1\\10d0\\10e5\\10d0\\10e0\\10d7\\10d5\\10d4\\10da\\10dd' ");

QSqlQuery qry("SELECT st_astext(way) FROM planet_osm_roads WHERE boundary='administrative' AND admin_level='2' AND name=U&'\\10e1\\10d0\\10e5\\10d0\\10e0\\10d7\\10d5\\10d4\\10da\\10dd' ");

To copy to clipboard, switch view to plain text mode 

You should use query parameters rather than pasting string fragments together when building the SQL. This is especially important if the name comes from a user.