質問編集履歴
1
テーブル構成を修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -13,8 +13,15 @@
|
|
|
13
13
|
MariaDB [db1]> insert into EncTEST002 (strName) values('坂本龍馬');
|
|
14
14
|
ERROR 1366 (22007): Incorrect string value: '\x8D\xE2\x96{\x97\xB4...' for column 'strName' at row 1
|
|
15
15
|
|
|
16
|
-
[テーブル
|
|
16
|
+
[テーブル]
|
|
17
|
+
CREATE TABLE `EncTEST002` (
|
|
18
|
+
`ID` varchar(50) DEFAULT NULL,
|
|
17
|
-
strName varchar(50)
|
|
19
|
+
`strName` varchar(50) DEFAULT NULL,
|
|
20
|
+
`strName_Enc` varbinary(1000) DEFAULT NULL,
|
|
21
|
+
`strMail` varchar(50) DEFAULT NULL,
|
|
22
|
+
`strMail_Enc` varbinary(1000) DEFAULT NULL,
|
|
23
|
+
`RegDate` datetime DEFAULT current_timestamp()
|
|
24
|
+
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 |
|
|
18
25
|
|
|
19
26
|
[文字コードの設定]
|
|
20
27
|
+--------------------------+-----------------------------------------------+
|