WampServer

Hi
May I found bug in MySQL Server 5.7.14.?!

WampServer 3.0.8 32bir, Windows 10 64bit

I execute this script
LOAD DATA LOCAL INFILE 'D:/CSV/gk.txt' INTO TABLE gk
FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'
IGNORE 1 LINES;

in MySQL Server 5.7.14 I got errors for two symbols
1. texts with symbol '\'
2. texts with wrong symbol '�'
In both cases error is "Invalid utf8 character string:"

BUT, when I use MySQL 5.6.35 (wampserver3_x86_addon_mysql5.6.35.exe) I HAVE NOT any errors!!!

file gk.txt is UTF-8
DataBase charset/collation is utf8/utf8_general_ci


the table is
----
CREATE TABLE gk (
ben_text varchar(420) NOT NULL COMMENT 'Текст'
)
ENGINE = MYISAM
CHARACTER SET utf8
COLLATE utf8_general_ci;

Both MySQL Servers have some values for
----
SHOW VARIABLES LIKE 'character_set%';
SHOW VARIABLES LIKE 'collation%';
===
character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8
character_sets_dir c:\wamp\bin\mysql\mysqlX.X.XX\share\charsets\

collation_connection utf8_general_ci
collation_database utf8_general_ci
collation_server latin1_swedish_ci



Edited 2 time(s). Last edit at 03/26/2017 12:42PM by bunak.

Hi,

See MySQL documentation and support.
And, if you think you have found a bug on mySQL, you have to report it to MySQL, not here; Wampserver is only a MySQL user, not the designer.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons



Edited 1 time(s). Last edit at 03/25/2017 03:50PM by Otomatic.

Yes, I will do it