stevocz
18th June 2013, 12:23
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\10da\10d d';
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 +"';");
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\10da\10d d';
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 +"';");