QtSql strange results after postgres stored function call

[golubevsv]

Hello. My program using postgresql database. I've migrated from Qt4 to Qt5, everything it's ok, but calling database stored functions, that returns Postgres "character varying" always returns empty string. Calling this function in CLI (psql) returns correct cyrillic string. Performing direct select-queries to database tables, containing cyrillic fields also returns correct cyrillic strings.

Also, calling all of stored functions thas return strings (even consists from latin characters) - returns an empty string.

[wysota]

Are there any threads involved?

[golubevsv]

No, this is usual GUI single-threaded application.

[wysota]

Can we see some actual code?

[golubevsv]

Thanks, i've found reason. I am using named parameters and bindValue of QSqlQuery. In my database tables and functions names look like "prefix$object_name". Escaping $ symbol fully solves the problem. Is it correct behaviour? I am not mixing named and positional parameters,