Allow chinese characters in saved_user_auth_info db table

[rmiccoli]

in particular, character set of the info_val column has been changed from latin1 to utf8.

This PR solves issue #700.

The error occurs when using MySQL 5.7 since:

• MySQL 5.7 has the default charset latin1 and default collation latin1_swedish_ci
• MySQL 8.0 has the default charset utf8mb4 and default collation utf8mb4_0900_ai_ci (which also accepts Chinese characters)

References:

• https://dev.mysql.com/doc/refman/5.7/en/charset.html
• https://dev.mysql.com/doc/refman/8.0/en/charset.html

[enricovianello]

Could you add a URL reference for the default MySQL charsets you mentioned? Thanks :)

[rmiccoli]

Could you add a URL reference for the default MySQL charsets you mentioned? Thanks :)

URLs added in the PR description! :)

[sonarcloud[bot]]

Quality Gate passed

Kudos, no new issues were introduced!

0 New issues
0 Security Hotspots
No data about Coverage
No data about Duplication

See analysis details on SonarCloud