← Back to team overview

maria-discuss team mailing list archive

New Question: Getting column names from the fields that use non-ANSI characters



A new question has been asked in "CONNECT" by evgenyko. Please answer it at http://mariadb.com/kb/en/getting-column-names-from-the-fields-that-use-non-ansi-characters/ as the person asking the question may not be subscribed to the mailing list.

I am trying to replicate example how to create pivot table like from MariaDB documentation:

Everything works as fine as explained. However, if I replace in source table fields 'Beer' with '啤酒‘ and 'Car' with 'машина‘, I get the following CREATE TABLE statement:

CREATE TABLE `pivex_cn` (
  `who` varchar(135) NOT NULL,
  `week` int(11) NOT NULL,
  `啤酒` decimal(6,2) NOT NULL `FLAG`=1,
  `Food` decimal(6,2) NOT NULL `FLAG`=1,
  `машина` decimal(6,2) NOT NULL `FLAG`=1

Which then in SELECT * FROM pivex_cn; gives the following error: "Error Code: 1296. Got error 122 'Cannot find matching column' from CONNECT"

All tables are using utf8 as default. I also tried uft8mb4, the same result :(


To view or answer this question please visit: http://mariadb.com/kb/en/getting-column-names-from-the-fields-that-use-non-ansi-characters/