I want to make a CONNECT table directed to a local CSV file saved in character set utf8.
The table data is correctly displayed but the header is corrupting.
Can I configure to fix this or is it a bug?
/var/lib/mysql/table_utf8.csv
[root@kc0022 ~]# cat /var/lib/mysql/table_utf8.csv
|
"COUPON_NUM","COUPON_NAME","START_DATE","END_DATE"
|
"A8772","CAMPAIGN1","2005-03-11","2005-04-01"
|
"A6703","ANNIVERSARY","2005-08-15","2005-09-05"
|
"A4313","NEW_ITEM","2005-09-13","2005-10-04"
|
CONNECT table on MariaDB
[root@kc0022 ~]# mysql -u root
|
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 351
|
Server version: 10.0.13-MariaDB MariaDB Server
|
|
Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.
|
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
|
MariaDB [(none)]> use test;
|
Reading table information for completion of table and column names
|
You can turn off this feature to get a quicker startup with -A
|
|
Database changed
|
MariaDB [test]> CREATE TABLE table_utf8
|
-> engine=CONNECT table_type=CSV file_name='../table_utf8.csv'
|
-> header=1 sep_char=',' quoted=1;
|
Query OK, 0 rows affected (0.05 sec)
|
|
MariaDB [test]> EXPLAIN table_utf8;
|
+----------------------------------------------------------------------+----------+------+-----+---------+-------+
|
| Field | Type | Null | Key | Default | Extra |
|
+----------------------------------------------------------------------+----------+------+-----+---------+-------+
|
| i≫?"i?£i? ̄i?μi?°i? ̄i?Ri??i?Ri?μi?-" | char(5) | NO | | NULL | |
|
| i?£i? ̄i?μi?°i? ̄i?Ri??i?Ri?!i?-i?\ | char(33) | NO | | NULL | |
|
| i?3i?´i?!i?2i?´i??i??i?!i?´i?\ | char(10) | NO | | NULL | |
|
| i?\i?Ri??i??i??i?!i?´i?\ | char(10) | NO | | NULL | |
|
+----------------------------------------------------------------------+----------+------+-----+---------+-------+
|
4 rows in set (0.05 sec)
|
|
MariaDB [test]> SELECT * FROM table_utf8;
|
+----------------------------------------------------------------------+--------------------------------------------------------------------+--------------------------------------------------------------+--------------------------------------------------+
|
| i≫?"i?£i? ̄i?μi?°i? ̄i?Ri??i?Ri?μi?-" | i?£i? ̄i?μi?°i? ̄i?Ri??i?Ri?!i?-i?\ | i?3i? ´i?!i?2i?´i??i??i?!i?´i?\ | i?\i?Ri??i??i??i?!i?´i?\ |
|
+----------------------------------------------------------------------+--------------------------------------------------------------------+--------------------------------------------------------------+--------------------------------------------------+
|
| A8772 | CAM PAIGN1 | 2005-03-11 | 2005-04-01 |
|
| A6703 | ANN IVERSARY | 2005-08-15 | 2005-09-05 |
|
| A4313 | NEW _ITEM | 2005-09-13 | 2005-10-04 |
|
+----------------------------------------------------------------------+--------------------------------------------------------------------+--------------------------------------------------------------+--------------------------------------------------+
|
3 rows in set (0.00 sec)
|
|
MariaDB [test]> show variables like "%char%";
|
+--------------------------+----------------------------+
|
| Variable_name | Value |
|
+--------------------------+----------------------------+
|
| character_set_client | utf8 |
|
| character_set_connection | utf8 |
|
| character_set_database | utf8 |
|
| character_set_filesystem | binary |
|
| character_set_results | utf8 |
|
| character_set_server | utf8 |
|
| character_set_system | utf8 |
|
| character_sets_dir | /usr/share/mysql/charsets/ |
|
+--------------------------+----------------------------+
|
8 rows in set (0.00 sec)
|
{"report":{"fcp":637,"ttfb":148.39999985694885,"pageVisibility":"visible","entityId":49523,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"202dbdb6-495e-4ad6-ae0f-912284bfd488","navigationType":0,"readyForUser":712.3999998569489,"redirectCount":0,"resourceLoadedEnd":683.7999999523163,"resourceLoadedStart":154.19999980926514,"resourceTiming":[{"duration":6.400000095367432,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":154.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":154.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":160.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":6.799999952316284,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":154.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":154.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":161.29999995231628,"responseStart":0,"secureConnectionStart":0},{"duration":61.700000047683716,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":154.59999990463257,"connectEnd":154.59999990463257,"connectStart":154.59999990463257,"domainLookupEnd":154.59999990463257,"domainLookupStart":154.59999990463257,"fetchStart":154.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":154.59999990463257,"responseEnd":216.29999995231628,"responseStart":216.29999995231628,"secureConnectionStart":154.59999990463257},{"duration":137.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":154.69999980926514,"connectEnd":154.69999980926514,"connectStart":154.69999980926514,"domainLookupEnd":154.69999980926514,"domainLookupStart":154.69999980926514,"fetchStart":154.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":154.69999980926514,"responseEnd":292,"responseStart":292,"secureConnectionStart":154.69999980926514},{"duration":141.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":154.79999995231628,"connectEnd":154.79999995231628,"connectStart":154.79999995231628,"domainLookupEnd":154.79999995231628,"domainLookupStart":154.79999995231628,"fetchStart":154.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":154.79999995231628,"responseEnd":295.89999985694885,"responseStart":295.89999985694885,"secureConnectionStart":154.79999995231628},{"duration":141.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":155,"connectEnd":155,"connectStart":155,"domainLookupEnd":155,"domainLookupStart":155,"fetchStart":155,"redirectEnd":0,"redirectStart":0,"requestStart":155,"responseEnd":296.59999990463257,"responseStart":296.59999990463257,"secureConnectionStart":155},{"duration":141.90000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":155.09999990463257,"connectEnd":155.09999990463257,"connectStart":155.09999990463257,"domainLookupEnd":155.09999990463257,"domainLookupStart":155.09999990463257,"fetchStart":155.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":155.09999990463257,"responseEnd":297,"responseStart":297,"secureConnectionStart":155.09999990463257},{"duration":142.30000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":155.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":155.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":297.5,"responseStart":0,"secureConnectionStart":0},{"duration":142.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":155.29999995231628,"connectEnd":155.29999995231628,"connectStart":155.29999995231628,"domainLookupEnd":155.29999995231628,"domainLookupStart":155.29999995231628,"fetchStart":155.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":155.29999995231628,"responseEnd":297.39999985694885,"responseStart":297.39999985694885,"secureConnectionStart":155.29999995231628},{"duration":142.40000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":155.39999985694885,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":155.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":297.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":142.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":155.5,"connectEnd":155.5,"connectStart":155.5,"domainLookupEnd":155.5,"domainLookupStart":155.5,"fetchStart":155.5,"redirectEnd":0,"redirectStart":0,"requestStart":155.5,"responseEnd":298,"responseStart":298,"secureConnectionStart":155.5},{"duration":516.9000000953674,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":156.09999990463257,"connectEnd":156.09999990463257,"connectStart":156.09999990463257,"domainLookupEnd":156.09999990463257,"domainLookupStart":156.09999990463257,"fetchStart":156.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":156.09999990463257,"responseEnd":673,"responseStart":673,"secureConnectionStart":156.09999990463257},{"duration":527.6000001430511,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":156.19999980926514,"connectEnd":156.19999980926514,"connectStart":156.19999980926514,"domainLookupEnd":156.19999980926514,"domainLookupStart":156.19999980926514,"fetchStart":156.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":156.19999980926514,"responseEnd":683.7999999523163,"responseStart":683.7999999523163,"secureConnectionStart":156.19999980926514},{"duration":239.60000014305115,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":437.19999980926514,"connectEnd":437.19999980926514,"connectStart":437.19999980926514,"domainLookupEnd":437.19999980926514,"domainLookupStart":437.19999980926514,"fetchStart":437.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":437.19999980926514,"responseEnd":676.7999999523163,"responseStart":676.7999999523163,"secureConnectionStart":437.19999980926514},{"duration":71.5,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":615.0999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":615.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":686.5999999046326,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":23,"responseStart":148,"responseEnd":152,"domLoading":152,"domInteractive":833,"domContentLoadedEventStart":833,"domContentLoadedEventEnd":877,"domComplete":1724,"loadEventStart":1724,"loadEventEnd":1726,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":812.8999998569489},{"name":"bigPipe.sidebar-id.end","time":813.6999998092651},{"name":"bigPipe.activity-panel-pipe-id.start","time":813.7999999523163},{"name":"bigPipe.activity-panel-pipe-id.end","time":816.1999998092651},{"name":"activityTabFullyLoaded","time":889.5999999046326}],"measures":[],"correlationId":"c57219f047f22d","effectiveType":"4g","downlink":9.2,"rtt":0,"serverDuration":67,"dbReadsTimeInMs":10,"dbConnsTimeInMs":16,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}