Lazarus

Programming => Databases => Topic started by: pcurtis on November 27, 2021, 02:30:32 pm

Title: [SOLVED] MySQL / MariaDB e2 80 93
Post by: pcurtis on November 27, 2021, 02:30:32 pm
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.
Title: Re: MySQL / MariaDB e2 80 93
Post by: dseligo on November 27, 2021, 11:51:27 pm
What exactly is the problem?

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

I made example project with your utf sequence.
Title: Re: [SOLVED] MySQL / MariaDB e2 80 93
Post by: pcurtis on November 28, 2021, 07:47:55 am
@dseligo Perfect. Problem with collation. Perfect demo.
Title: Re: [SOLVED] MySQL / MariaDB e2 80 93
Post by: dseligo on November 28, 2021, 05:29:28 pm
Np, I'm glad to help you
TinyPortal © 2005-2018