search

MariaDB / mariadb_kernel

A MariaDB Jupyter kernel
BSD 3-Clause "New" or "Revised" License
30 stars 21 forks source link

Diacritics strings result in errors coming from the MariaDB Client #20

Open robertbindar opened 3 years ago

robertbindar commented 3 years ago

image

a97410985 commented 3 years ago

some discovery

In beginning, I can't reproduce this error. Like the image below diacritics_string_data_success I think this error is about the character set, so I query my database. (show below) query_database_characterset Like the above image, tests the database's default character set is utf8mb4, which cover all character(such as Chinese, Diacritics...etc) And when I create a database that is a Latin character set. Would have 「ERROR 1366」 error like below. latin_character_set_error

some ideas

when occurring 「ERROR 1366」would show a more friendly message for directing the user to change their database character set to be utf8mb4 or we set all database to be utf8mb4 by default