Is this bug in MySQL Server 5.7.14?
Hi
May I found bug in MySQL Server 5.7.14.?!
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 inside gk.txt
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 - 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
Subject
Views
Written By
Posted
Is this bug in MySQL Server 5.7.14?
2684
March 26, 2017 07:41AM
1074
March 26, 2017 10:43AM
1262
March 26, 2017 11:33AM
1148
March 26, 2017 12:11PM
1056
March 26, 2017 12:24PM
989
March 26, 2017 02:34PM
1039
March 27, 2017 04:50AM
1018
March 27, 2017 10:56AM
1039
March 27, 2017 12:33PM
1610
March 27, 2017 02:55PM
956
March 27, 2017 03:03PM
969
March 27, 2017 03:32PM
1095
March 27, 2017 10:10PM
958
March 27, 2017 10:17PM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.