Bug #92969 | Unable to query non-English chars - ONLY via Connector. | ||
---|---|---|---|
Submitted: | 26 Oct 2018 14:19 | Modified: | 28 Oct 2018 18:57 |
Reporter: | Itamar Shoham | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Visual Studio Integration | Severity: | S2 (Serious) |
Version: | 8.0.13 | OS: | Windows (10) |
Assigned to: | CPU Architecture: | x86 | |
Tags: | Unicode |
[26 Oct 2018 14:19]
Itamar Shoham
[26 Oct 2018 16:33]
MySQL Verification Team
Thank you for the bug report. Please provide the test code file (attach here using the Files tab). Thanks.
[27 Oct 2018 17:58]
Itamar Shoham
Since no code is needed to reproduce the bug, I'll describe the steps in greater detail: 1. use 3rd party to connect to the db. (I used HeidiSQL - https://www.heidisql.com/) 2. create test table, add test rows: -- create the test table CREATE TABLE `test_table` ( `ID` INT(11) NOT NULL AUTO_INCREMENT, `NON_ENG_WORD` VARCHAR(50) NOT NULL COLLATE 'utf8_bin', `ENG_WORD` VARCHAR(50) NOT NULL COLLATE 'utf8_bin', PRIMARY KEY (`ID`) ) COLLATE='utf8_bin' ENGINE=InnoDB AUTO_INCREMENT=12; -- insert test row. INSERT INTO `test_table` (`NON_ENG_WORD`, `ENG_WORD`) VALUES ('Привет', 'Hello'); 3. Open Visual studio 2017 4. menu -> View -> toolbars -> MySQL 5. on the new toolbar, click on "MySQL script with new connection" 6. provide connection details 7. on the new query window, run the following commands: -- this query will return 1 row. SELECT * FROM test_table WHERE ENG_WORD = 'Hello'; -- this query will return 0 rows! and this is WRONG. SELECT * FROM test_table WHERE NON_ENG_WORD = 'Привет';
[27 Oct 2018 20:11]
Itamar Shoham
Tested with Development Release Version 2.0.5 m4, and had the exact same issue. please help.
[28 Oct 2018 18:05]
MySQL Verification Team
Thank you for the bug report. What you wrote as workaround isn't a workaround it's the correct way to handle handle non-English characters which is to use the correct character set and collation, so !bug.