Improve UTF-8 support
Implement LV-encoding -> UTF-8 support for queries and responses. Fix the column type bug with field type TEXT
, also see https://gitlab.com/hampel-soft/open-source/hse-db/-/issues/9.
Problem
With both DB servers, MySQL 8 and MariaDB 10, the server responds for colum type TEXT
with FIELD_TYPE_BLOB
(252). Field type definitions see here: https://mariadb.com/kb/en/result-set-packets/#field-types and https://dev.mysql.com/doc/dev/mysql-server/latest/field__types_8h.html.
Data and information to reproduce and test
To better reproduce and test the driver behavior, I created an example table with some test data.
VarChar_Text_utf-8_Example_Table.sql
The following files are Wireshark capture files containing the network communication of a simple SELECT * FROM test;
:
- MariaDBv version 10.8.3: MariaDB_simple_SELECT_with_VARCHAR_TEXT_utf-8.pcapng
- MySQL version 8.0.30: MySQL_8_simple_SELECT_with_VARCHAR_TEXT_utf-8.pcapng
Edited by Administrator