set charset on Connect/LazyConnect?

[recarv]

Hello,

We're running into issues while testing on mySQL8 whereby we're getting errors like:

Error: Incorrect DATE value: ''"

when passing a query like "select * from table where datecol='2019-04-01'". Our first inclination was it was a sql_mode problem (as that what most google hits lead), except the date value we're using in the where statement is valid.

After a good deal of debugging we believe it has to do with query being passed in without an explicit ability to indicate the client's charset. For example, when using a PDO connection and a DSN string like the following:

$dsn="mysql:host=" .$shard_host.";port=".$shard_port.";dbname=mysql;charset=utf8";

The proper result is returned. However if we convert this to the URI format required for this library:

$uri=user:pass@host:port/mysql

We receive the error mentioned above.

We also tried:

$uri=user:pass@host:port/mysql?charset=utf8

to see if this might work, but it does not. How can we explicitly set the client charset so that the server interprets this correctly?

[ghost]

Explicitely send a SET NAMES "utf8mb4" query. Explicit support for setting the charset and collation should probably be added to this library, as I've added to my project https://github.com/PlasmaPHP/driver-mysql/blob/3d706bef7c0cc96235c2931a2413dd972fad5b5a/src/Driver.php#L269. PRs for this are probably accepted.

[clue]

@recarv Thanks for bringing this up!

I agree sending a SET NAMES "utf8mb4" query is probably a good idea 👍

We've successfully used this library to send UTF-8 data back and forth with MySQL. I don't see how this could be related to the error you're seeing otherwise.

I believe this has been answered, so I'm closing this for now. Please come back with more details if this problem persists and we can always reopen this 👍

[clue]

See also #135