Re: [Maria-discuss] execute failed: Incorrect string value: '\xD6sterl...' with mariadb and perl DBD

2019-06-25 Thread Alessandro Ren
Hey Dave, I had some problems dealing with wrong coded UTF-8 chars. You have to either deal with them before sending them to MariaDB, trying to detect if the string is encoded correctly or you can change the field type to blob, which will accept this string as is and not thrown a invalid

Re: [Maria-discuss] execute failed: Incorrect string value: '\xD6sterl...' with mariadb and perl DBD

2019-06-20 Thread Felipe Gasper
Hi Dave, You can convert iso8859-1 to UTF8 using the iconv utility. Then feed the output into MariaDB. -FG > On Jun 19, 2019, at 2:21 PM, Dave Wreski wrote: > > Hi Felipe, > >> On 6/19/19 1:59 PM, Felipe Gasper wrote: >> It looks like your input, with “Ö” as a single byte \xd6, is not >>

Re: [Maria-discuss] execute failed: Incorrect string value: '\xD6sterl...' with mariadb and perl DBD

2019-06-19 Thread Dave Wreski
Hi Felipe, On 6/19/19 1:59 PM, Felipe Gasper wrote: It looks like your input, with “Ö” as a single byte \xd6, is not UTF-8. Any Unicode code point above 127 requires at least 2 bytes in UTF-8. So if MySQL is expecting UTF-8, it may be choking on what it sees as invalid input. It's from an

[Maria-discuss] execute failed: Incorrect string value: '\xD6sterl...' with mariadb and perl DBD

2019-06-19 Thread Dave Wreski
Hi, I'm trying to use perl-DBD to write a buffer of text that contains an email with umlauts and other non-ASCII characters to a joomla database and having a problem. DBD::mysql::st execute failed: Incorrect string value: '\xD6sterl...' for column