Is this bug in MySQL Server 5.7.14?
Posted by: bunak (---.50.90.212.it-tv.org)
Date: March 25, 2017 01:27PM

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.

Options: ReplyQuote
Re: Is this bug in MySQL Server 5.7.14?
Posted by: Otomatic (Moderator)
Date: March 25, 2017 03:02PM

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.

------------------------------------------------------------------------------------------------------------
(W7 Pro 64 bit)-Wampserver 3.1.0 32 bit - Apache 2.4.27 - PHP 7.1.9/7.0.23/5.6.31 - MySQL 5.7.19 - MariaDB 10.2.8
Wampserver 3.1.0 64 bit - Apache 2.4.27 - PHP 7.1.9/7.0.23/5.6.31 - MySQL 5.7.19 - MariaDB 10.2.8
PhPMyAdmin 4.7.4 - MysqlDumper 1.24.5

Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »



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

Options: ReplyQuote
Re: Is this bug in MySQL Server 5.7.14?
Posted by: bunak (---.50.90.212.it-tv.org)
Date: March 26, 2017 12:42PM

Yes, I will do it

Options: ReplyQuote


Sorry, only registered users may post in this forum.