Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: _UTF8 in front of all paramstrings not wanted


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 1 - Last Post: Apr 1, 2017 9:37 PM Last Post By: Dmitry Arefiev
Ake Pettersson

Posts: 3
Registered: 9/16/12
_UTF8 in front of all paramstrings not wanted  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Mar 30, 2017 4:37 AM
Hello,

I like to startusing FDQuery1.Params[0].AsString := LoadMcid;
But when I do ExeSQL I got an exception and the error message showa me that _UTF8 is put in front of my variable "LoadMcid" ="ID0001" but in the error mdg it is "_UTF8ID0001".

The connected DB are MariaDB 10.0.2, uerys without "params" works fine, I suppose it is some settings some were but where?

Using Delphi 10.2 Tokyo

Best.. Ă…ke
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: _UTF8 in front of all paramstrings not wanted  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Apr 1, 2017 9:37 PM   in response to: Ake Pettersson in response to: Ake Pettersson
1) Could you please provide FireDAC environment report and error text ?
2) If you will set connection definition parameter CharacterSet=cp1250, then probably issue will be resolved.

--
With best regards,
Dmitry
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02