Lazarus
Home
Help
TinyPortal
Search
Login
Register
Lazarus
»
Forum
»
Programming
»
Databases
»
[SOLVED] MySQL / MariaDB e2 80 93
Free Pascal
Website
Downloads
Wiki
Documentation
Bugtracker
Mailing List
Lazarus
Website
Downloads (Laz+FPC)
Packages (OPM)
FAQ
Wiki
Documentation (RTL/FCL/LCL)
Bugtracker
CCR Bugs
IRC channel
GIT
Mailing List
Other languages
Foundation
Website
Useful Wiki Links
Project Roadmap
Getting the Source
Screenshots
How to use the forum
About donations (wiki)
Bookstore
Computer Math and Games in Pascal
(preview)
Lazarus Handbook
Search
Advanced search
Recent
Computational Language Tr...
by
AlexTP
[
Today
at 02:55:23 am]
Poll: Watches and Display...
by
440bx
[
Today
at 01:08:58 am]
Free AI to use in local
by
gidesa
[March 29, 2024, 10:14:48 pm]
Program loop "runaway" wh...
by
Thaddy
[March 29, 2024, 09:34:48 pm]
A "leisure" question on W...
by
EventHorizon
[March 29, 2024, 09:29:50 pm]
Unable to open the packag...
by
LazKuri
[March 29, 2024, 08:42:25 pm]
Your best UI design - con...
by
mgc
[March 29, 2024, 08:33:26 pm]
Slight improvement for la...
by
n7800
[March 29, 2024, 07:18:44 pm]
Controlling the behavior ...
by
1HuntnMan
[March 29, 2024, 04:55:21 pm]
Making panels with lots o...
by
lainz
[March 29, 2024, 04:00:20 pm]
Ribbon bar in Lazarus 3.2...
by
lainz
[March 29, 2024, 03:58:42 pm]
Have anyone develop UEFI ...
by
PascalDragon
[March 29, 2024, 02:16:40 pm]
Dynarray initialization p...
by
PascalDragon
[March 29, 2024, 02:12:47 pm]
STARS and Regular POLYGON...
by
Boleeman
[March 29, 2024, 02:05:38 pm]
how to change the color f...
by
cdbc
[March 29, 2024, 12:02:27 pm]
Understanding and adjusti...
by
ArchChem
[March 29, 2024, 11:49:35 am]
Offical launch of the 1 B...
by
abouchez
[March 29, 2024, 11:14:35 am]
Using KeyPress event, how...
by
KodeZwerg
[March 29, 2024, 10:44:31 am]
Big Numbers Math
by
Thaddy
[March 29, 2024, 07:22:49 am]
Parquet?
by
Thaddy
[March 29, 2024, 07:11:17 am]
Project fails on run but ...
by
jamie
[March 29, 2024, 12:54:49 am]
Curling Pythagoras Tree: ...
by
Boleeman
[March 29, 2024, 12:00:37 am]
how to search in rxmemory...
by
rcmz
[March 28, 2024, 10:19:54 pm]
Configure JCF messages
by
GordonFindlay
[March 28, 2024, 10:16:19 pm]
Dialog ShowModal and an i...
by
d7_2_laz
[March 28, 2024, 09:51:39 pm]
« previous
next »
Print
Pages: [
1
]
Author
Topic: [SOLVED] MySQL / MariaDB e2 80 93 (Read 5072 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
»
Logged
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.
Logged
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.
Logged
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
Logged
Print
Pages: [
1
]
« previous
next »
Lazarus
»
Forum
»
Programming
»
Databases
»
[SOLVED] MySQL / MariaDB e2 80 93
TinyPortal
© 2005-2018