ASCII collation

[marcus-clements]

Why does it need to be ASCII collation?
The mysql only command means I can't use sqlite in testing which is a shame.

thanks

Marcus

[shamiao]

A mistake was made. I simply don't understand why I wrote code like this a season ago...

createPayload() in Illuminate\Queue\Queue always calls json_encode() to generate a ASCII JSON format payload string. I may once thought that ASCII collation helps for avoiding any encoding troubles. But:

• ASCII is the smallest charset, won't cause any problem in any other larger charset.
• A simple binary field (mysql BLOB) can also store raw text and bypass encoding conversions.

Considering using BLOB mades payload string unable to read directly in phpMyAdmin, I prefer creating table with native l4 schema builder, and change collation of payload column to ASCII only if database driver is MySQL.

Thank you for this issue 👍 , an upgrade is coming this week.