Unicode/UTF-8 Characters

[Weetch_Russell (Russell Weetch)]

I wonder if anyone can help with this.

My set up is Webcore / XData with a Firebird 4 database (UTF-8).

I complete some data on the webform Latěž Čedonir

This value is what I see being submitted to the server and I can verify this in the Entity OnInserting method.

However, by the time it reaches the database it is Latež Cedonir

Any idea how to preserve the correct characters? thanks

[wlandgraf (Wagner Landgraf)]

Have you tried this:

Chinese Word Probllems

Well, you are not creating the database field as Unicode, nor asking Aurelius to use Unicode. In this case, it will not work indeed. Easier way is to do this at the beginning of your application: uses Aurelius.Global.Config; TGlobalConfigs.GetInstance.MapStringToNationalChar := True;

Also, try first to isolate the problem, using your existing connection settings, are you able to property save such value directly in the database using SQL and your db-access query component you're using?

[Weetch_Russell (Russell Weetch)]

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