Re: Storing UTF-8 data into database from scraped web page

Note that DBD::mysql is broken, especially its encoding support. You might try DBD::MariaDB instead - it's not yet production ready, but it tries to fix all the old problems. See the mailing list for the announcement and links to details.

($q=q:Sq=~/;[c](.)(.)/;chr(-||-|5+lengthSq)`"S|oS2"`map{chr |+ord
}map{substrSq`S_+|`|}3E|-|`7**2-3:)=~y+S|`+$1,++print+eval$q,q,a,
[download]

Comment on Re: Storing UTF-8 data into database from scraped web page Download Code

Replies are listed 'Best First'.
Re^2: Storing UTF-8 data into database from scraped web page by Your Mother (Archbishop) on Jun 14, 2018 at 20:55 UTC
I have no illusions that MySQL or its clients are top shelf tools but I have been using DBD::mysql for almost 20 years at this point without anything I would call broken behavior, just lots of terrible default behavior that acts broken until you sort it out. So could you elaborate on the broken encoding support?	[reply]
Re^3: Storing UTF-8 data into database from scraped web page by choroba (Cardinal) on Jun 14, 2018 at 21:06 UTC
See for example #20, #23, #35, or #47. See also dbdimp.c:5933 and below on how numbers were recognized in DBD::mysql. For more information, read any other pull request. ($q=q:Sq=~/;[c](.)(.)/;chr(-\|\|-\|5+lengthSq)`"S\|oS2"`map{chr \|+ord }map{substrSq`S_+\|`\|}3E\|-\|`7**2-3:)=~y+S\|`+$1,++print+eval$q,q,a, [download]	[reply] [d/l]