Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re: DBD::mysql incorrect string value

by parv (Vicar)
on Apr 10, 2021 at 07:07 UTC ( #11131081=note: print w/replies, xml ) Need Help??


in reply to DBD::mysql incorrect string value

Is it not possible to change the table/database encoding to "utf8mb4"? Or, would that also not be enough for MySQL to deal with Unicode?

Replies are listed 'Best First'.
Re^2: DBD::mysql incorrect string value
by cormanaz (Deacon) on Apr 10, 2021 at 19:38 UTC
    Doh! Why didn't I think of that? Thanks, that did the trick.

      If you care about Unicode in UTF-8 to|from MySQL, I do hope that you would switch to DBD::MariaDB as choroba mentioned.

      Thanks goes to Adam H for reminding me about broken "utf8" encoding scheme of MySQL & to use "utf8mb4" instead few days ago, and all the other people through whom I found previously linked article written in 2016. Some web! 8-)

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11131081]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (4)
As of 2022-12-06 21:46 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?