Recent

Author Topic: [SOLVED] MySQL / MariaDB e2 80 93  (Read 5070 times)

pcurtis

  • Hero Member
  • *****
  • Posts: 951
[SOLVED] MySQL / MariaDB e2 80 93
« 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.
« Last Edit: November 28, 2021, 07:45:03 am by pcurtis »
Windows 10 20H2
Laz 2.2.0
FPC 3.2.2

dseligo

  • Hero Member
  • *****
  • Posts: 1196
Re: MySQL / MariaDB e2 80 93
« Reply #1 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.

pcurtis

  • Hero Member
  • *****
  • Posts: 951
Re: [SOLVED] MySQL / MariaDB e2 80 93
« Reply #2 on: November 28, 2021, 07:47:55 am »
@dseligo Perfect. Problem with collation. Perfect demo.
Windows 10 20H2
Laz 2.2.0
FPC 3.2.2

dseligo

  • Hero Member
  • *****
  • Posts: 1196
Re: [SOLVED] MySQL / MariaDB e2 80 93
« Reply #3 on: November 28, 2021, 05:29:28 pm »
Np, I'm glad to help you

 

TinyPortal © 2005-2018