嗨, 大家好: 网站在新年后正式开通,欢迎大家加入我们,共同维护一个良好氛围的中国技术社区。 欢迎举报不良帖子,欢迎提供建议。
我们的QQ群:136102234,欢迎进群找答案,里边会有很多资深的大师们。 point overflow

我需求是这样的: version:mysql5.6
sql_mode:STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION 能确定大概是STRICT_TRANS_TABLES的问题,但是为何这个会报错?纠结了一天没找到原因。

-- 建表 create table test.global_variables_test_copy like information_schema.global_variables ; -- 插入数据 insert into test.global_variables_test_copy select VARIABLE_NAME,VARIABLE_VALUE from information_schema.global_variables limit 1;

但是就报错了:

[SQL]insert into test.global_variables_test_copy select VARIABLE_NAME,VARIABLE_VALUE from information_schema.global_variables limit 1; [Err] 1366 - Incorrect string value: '\xD6\xD0\xB9\xFA\xB1\xEA...' for column 'VARIABLE_VALUE' at row 1

asked 2016-05-20 16:55:33

jkant's gravatar image

jkant ♦♦
11135138139
accept rate: 3%


。。。没以前还是没有解决!!!

link

answered 2016-05-27 18:22:14

jkant's gravatar image

jkant ♦♦
11135138139
accept rate: 3%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×72
×1
×1

Asked: 2016-05-20 16:55:33

Seen: 1,563 times

Last updated: 2016-05-27 18:22:14