質問編集履歴
2
誤字訂正しました。
test
CHANGED
File without changes
|
test
CHANGED
@@ -234,6 +234,8 @@
|
|
234
234
|
|
235
235
|
###追記
|
236
236
|
|
237
|
+
```
|
238
|
+
|
237
239
|
clearDBのMySQLサービスインスタンス内の文字コード
|
238
240
|
|
239
241
|
(win10コマンドプロンプト経由で確認。)
|
@@ -291,3 +293,7 @@
|
|
291
293
|
+------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
|
292
294
|
|
293
295
|
1 row in set (0.20 sec)
|
296
|
+
|
297
|
+
|
298
|
+
|
299
|
+
```
|
1
文字コード情報を追記しました。
test
CHANGED
File without changes
|
test
CHANGED
@@ -227,3 +227,67 @@
|
|
227
227
|
[使用DB]
|
228
228
|
|
229
229
|
Cleardb MySQL(CloudFoundryのサービスインスタンス)
|
230
|
+
|
231
|
+
|
232
|
+
|
233
|
+
|
234
|
+
|
235
|
+
###追記
|
236
|
+
|
237
|
+
clearDBのMySQLサービスインスタンス内の文字コード
|
238
|
+
|
239
|
+
(win10コマンドプロンプト経由で確認。)
|
240
|
+
|
241
|
+
|
242
|
+
|
243
|
+
【データベースの文字コード】
|
244
|
+
|
245
|
+
mysql> show create database データベース名 ;
|
246
|
+
|
247
|
+
+--------------------+-----------------------------------------------------------------------------+
|
248
|
+
|
249
|
+
| Database | Create Database |
|
250
|
+
|
251
|
+
+--------------------+-----------------------------------------------------------------------------+
|
252
|
+
|
253
|
+
| データベース名 | CREATE DATABASE `データベース名` /*!40100 DEFAULT CHARACTER SET utf8 */ |
|
254
|
+
|
255
|
+
+--------------------+-----------------------------------------------------------------------------+
|
256
|
+
|
257
|
+
1 row in set (0.19 sec)
|
258
|
+
|
259
|
+
|
260
|
+
|
261
|
+
【テーブルの文字コード】
|
262
|
+
|
263
|
+
mysql> show create table テーブル名;
|
264
|
+
|
265
|
+
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
266
|
+
|
267
|
+
| Table | Create Table |
|
268
|
+
|
269
|
+
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
270
|
+
|
271
|
+
| テーブル名 | CREATE TABLE `テーブル名` (カラム定義) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 |
|
272
|
+
|
273
|
+
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
274
|
+
|
275
|
+
1 row in set (0.17 sec)
|
276
|
+
|
277
|
+
|
278
|
+
|
279
|
+
【ビューの文字コード】
|
280
|
+
|
281
|
+
mysql> show create view ビュー名;
|
282
|
+
|
283
|
+
+------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
|
284
|
+
|
285
|
+
| View | Create View | character_set_client | collation_connection |
|
286
|
+
|
287
|
+
+------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
|
288
|
+
|
289
|
+
| ビュー名 | ビューの生成規則 | utf8 | utf8_general_ci |
|
290
|
+
|
291
|
+
+------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
|
292
|
+
|
293
|
+
1 row in set (0.20 sec)
|