質問編集履歴
2
文字コードの確認とpostの値の確認を追記しました。
test
CHANGED
File without changes
|
test
CHANGED
@@ -168,6 +168,38 @@
|
|
168
168
|
|
169
169
|
```
|
170
170
|
|
171
|
+
Postのログを確認したら、日本語でpostされていたので、DB側の問題なの[サイト](https://proengineer.internous.co.jp/content/columnfeature/6653)を参考にして文字コードの確認
|
172
|
+
|
173
|
+
```MySQL
|
174
|
+
|
175
|
+
MariaDB [stock_db02]> show variables like "chara%";
|
176
|
+
|
177
|
+
+--------------------------+--------------------------------+
|
178
|
+
|
179
|
+
| Variable_name | Value |
|
180
|
+
|
181
|
+
+--------------------------+--------------------------------+
|
182
|
+
|
183
|
+
| character_set_client | cp932 |
|
184
|
+
|
185
|
+
| character_set_connection | cp932 |
|
186
|
+
|
187
|
+
| character_set_database | latin1 |
|
188
|
+
|
189
|
+
| character_set_filesystem | binary |
|
190
|
+
|
191
|
+
| character_set_results | cp932 |
|
192
|
+
|
193
|
+
| character_set_server | latin1 |
|
194
|
+
|
195
|
+
| character_set_system | utf8 |
|
196
|
+
|
197
|
+
| character_sets_dir | C:\xampp\mysql\share\charsets\ |
|
198
|
+
|
199
|
+
+--------------------------+--------------------------------+
|
200
|
+
|
201
|
+
```
|
202
|
+
|
171
203
|
|
172
204
|
|
173
205
|
### 補足情報(FW/ツールのバージョンなど)
|
1
DBのカラムのデータ型を追加しました。
test
CHANGED
File without changes
|
test
CHANGED
@@ -78,7 +78,33 @@
|
|
78
78
|
|
79
79
|
```
|
80
80
|
|
81
|
+
```DBのカラムのデータ型
|
81
82
|
|
83
|
+
MariaDB [stock_db02]> show columns from orders;
|
84
|
+
|
85
|
+
+----------------+------------------+------+-----+---------+----------------+
|
86
|
+
|
87
|
+
| Field | Type | Null | Key | Default | Extra |
|
88
|
+
|
89
|
+
+----------------+------------------+------+-----+---------+----------------+
|
90
|
+
|
91
|
+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
|
92
|
+
|
93
|
+
| ordername | varchar(255) | YES | | NULL | |
|
94
|
+
|
95
|
+
| order_price | varchar(255) | YES | | NULL | |
|
96
|
+
|
97
|
+
| order_quantity | varchar(255) | YES | | NULL | |
|
98
|
+
|
99
|
+
| order_status | varchar(255) | YES | | NULL | |
|
100
|
+
|
101
|
+
| created | datetime | YES | | NULL | |
|
102
|
+
|
103
|
+
| modified | datetime | YES | | NULL | |
|
104
|
+
|
105
|
+
+----------------+------------------+------+-----+---------+----------------+
|
106
|
+
|
107
|
+
```
|
82
108
|
|
83
109
|
### 試したこと
|
84
110
|
|