Posted by : dudi Wednesday, February 28, 2018

Delphi PostgreSQL Unicode


If Delphi Project raise exception class EDatabaseError with message ... Type mismatch for field NAME, expecting: String actual: WideString.

Using the Devart dbExpress driver (4.40.0.14) the following params must be set on TSQLConnection:

UseUnicode=True
Charset=utf8


this way stringfields get mapped into TWideString field, so the original issue has been solved.

http://www.experts-exchange.com/Programming/Editors_IDEs/Delphi/Q_24037993.html

go to link download

Blog Archive