質問編集履歴

2

誤字訂正しました。

2017/11/12 03:32

投稿

osatsu
osatsu

score6

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

文字コード情報を追記しました。

2017/11/12 03:32

投稿

osatsu
osatsu

score6

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)