Unicode / UTF-8 Characters - Revisited

BIZ TMS XData
1

You might recall I said this

Solution was fairly straightforward
I had this in my configuration of the database connection
`FConnection.Params.add('CharacterSet=UTF8');`
changed it to
`TFDPhysFBConnectionDefParams(FConnection.Params).CharacterSet := TIBCharacterSet.csUTF8;`
And that did the trick

Well that wasn't it. The impact of both approaches is the same.

So I tested direct

  • a TFDQuery insert,
  • a IDBStatement to do the insert
  • and Aurelius.

The first 2 were fine, but it failed on Aurelius.

The solution was the one referred to in https://support.tmssoftware.com/t/chinese-word-probllems/21511/10

uses
  Aurelius.Global.Config;

TGlobalConfigs.GetInstance.MapStringToNationalChar := True;

I thought I'd post an update to save people chasing around if they have the same issue

1 Like