30 July 2010

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

No comments: