[SOLVED] MySQL / MariaDB e2 80 93
lazarus / 16-Databases

----------------------------------------------------------------------
pcurtis · 2021-11-27 13:30

I have a string that contains the utf sequence e2 80 93.
How do I put that into my DB.

i use zeos, with parameterized queries.

----------------------------------------------------------------------
dseligo · 2021-11-27 22:51

What exactly is the problem?

Doesn't this work for you:
ZQuery1.ParamByName('yourcolumn').AsString := YourUtfString;

I made example project with your utf sequence.

----------------------------------------------------------------------
pcurtis · 2021-11-28 06:47

@dseligo Perfect. Problem with collation. Perfect demo.

----------------------------------------------------------------------
dseligo · 2021-11-28 16:29

Np, I'm glad to help you