jacktengg commented on code in PR #11863: URL: https://github.com/apache/doris/pull/11863#discussion_r947756269
########## docs/en/docs/ecosystem/external-table/odbc-of-doris.md: ########## @@ -381,5 +381,8 @@ This is the compatibility problem between MySQL database ODBC driver and existin Connection to the database fails. The` Err: part` represents the error of different database connection failures. This is usually a configuration problem. You should check whether the IP address, port or account password are mismatched. - + 11. Messy code appears when reading and writing emoji emoji in mysql odbc table + + The default encoding used by Doris when connecting to odbc tables is utf8, since the default utf8 encoding in mysql is utf8mb3, it can't represent the emoji expressions which need 4-byte encoding. Here need to set `charset`=`utf8mb4` when you create odbc mysql tables, then can read and write emoji emojis normally 😀. Review Comment: 'emoji emojis' typos? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org