[SOLVED] SQLDB: UTF8 problem in Postgresql

[mmelwin]

I have set:

Code: Pascal  [Select][+][-]

1.   SQL1.SQL.Clear;
2.   SQL1.SQL.Add('SET CLIENT_ENCODING TO ''UTF8'';');
3.   SQL1.ExecSQL;

But when moving values from one query to another. When a string contains national characters.

Code: Pascal  [Select][+][-]

1. SQL1.SQL.Add('and m='''+Form1.SQLQueryTre['m']+'''');

I have an error:

Code: Pascal  [Select][+][-]

1. Invalid byte sequence for encoding "UTF8"

What could be wrong?

[winni]

Hi!

Three apostrophe in the beginning and 4 in the end - that does not fit.

To get rid of the eyepowder '''' use #39!

Winni

[lucamar]

No, the apostrophes are all right as they are. The problem has to be in:
Form1.SQLQueryTre['m']
Check what it is returning (both as chars and as bytes); it's possible that at some point or other it's getting converted to some Windows/ISO code-page and it's not re-converting back to UTF-8.

[mmelwin]

Everything was explained.
However, the problem was with another string.
Project is from delphi 2007 conversion.
Some *.pas files were in ANSI and not UTF8.
Everything works after conversion.