[MXS-3920] Can't connect to MaxScale when schema uses utf8mb4 chars >= U0080 Created: 2021-12-17  Updated: 2022-01-03  Resolved: 2022-01-03

Status: Closed
Project: MariaDB MaxScale
Component/s: Core
Affects Version/s: 2.5.9
Fix Version/s: 2.5.18, 6.2.1

Type: Bug Priority: Major
Reporter: Georg Richter Assignee: markus makela
Resolution: Fixed Votes: 0
Labels: None


 Description   

If a schema name contains a unicode character > U0080 MaxScale returns an error, when trying to connect with schema.

How to repeat:

mysql -P4006 -pfoo -umax -h127.0.0.1 -e"create schema €uro"
 
mysql -P4006 -pfoo -umax -h127.0.0.1 -e"show schemas like '€uro'\G"
 
*************************** 1. row ***************************
 
Database (€uro): €uro
 
mysql -P4006 -pfoo -umax -h127.0.0.1 €uro
 
ERROR 1049 (42000): Unknown database '€uro'



 Comments   
Comment by markus makela [ 2022-01-03 ]

Seems like it might just be the client character set that causes this. A simple SET NAMES utf8mb4 before the internal queries are done seems to solve this particular problem.

Generated at Thu Feb 08 04:24:54 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.