GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — MySQL Supported Encoding

MySQL Supported Encoding

Jump to bottom
Ohad Shai edited this page Apr 22, 2019 · 1 revision

Out-of-the-box jasync supported those types of encoding:

  • UTF_8
  • US_ASCII
  • ISO_8859_1

The default one is UTF_8.

In version 0.9.50 the encoding used for UTF-8 was changed from utf8mb3 to utf8mb4_unicode_ci. Effectively, it allows passing UTF chars of up to 4 bytes, Including emoji's.

In case you would like to use other charsets there are 2 options:

  • Configure Charset and CharsetMapping via configuration and connection construction. This methods is a bit tricky but supported. You can see here the usage: https://github.com/jasync-sql/jasync-sql/blob/master/mysql-async/src/main/java/com/github/jasync/sql/db/mysql/util/CharsetMapper.kt
  • Add a JVM property: -DjasyncMysqlUTF8Collation=83 (or replace 83 with the one you want to use). This will change the default encoding itself.

For more details you can see the PR: https://github.com/jasync-sql/jasync-sql/pull/115

List of unicode charsets can be seen here: https://dev.mysql.com/doc/refman/8.0/en/charset-mysql.html

Clone this wiki locally

You are visitor 01402520 — GeezerVison does not store the pages you look up.
Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.