Skip to content

Instantly share code, notes, and snippets.

@dezinezync
Last active October 7, 2023 03:23
Show Gist options
  • Save dezinezync/6c98562584295ae83047bfe067c19689 to your computer and use it in GitHub Desktop.
Save dezinezync/6c98562584295ae83047bfe067c19689 to your computer and use it in GitHub Desktop.
Vapor-Fluent with MySQL: incorrect character set used

Base Query

SELECT * FROM performance_schema.session_variables
WHERE VARIABLE_NAME IN (
 'character_set_client', 'character_set_connection',
 'character_set_results', 'collation_connection'
) ORDER BY VARIABLE_NAME;

Sequel Pro

VARIABLE_NAME VARIABLE_VALUE
character_set_client utf8mb4
character_set_connection utf8mb4
character_set_results utf8mb4
collation_connection utf8mb4_general_ci

Fluent

VARIABLE_NAME VARIABLE_VALUE
character_set_client latin1
character_set_connection latin1
character_set_results latin1
collation_connection latin1_swedish_ci

Vapor-Fluent Configuration

app.databases.use(
    .mysql(
      hostname: readHostname,
      port: port,
      username: username,
      password: password,
      database: DB_NAME,
      tlsConfiguration: tlsConfig,
      maxConnectionsPerEventLoop: 5
    ),
    as: .readDB
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment