質問編集履歴
2
誤字訂正しました。
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -116,6 +116,7 @@
|
|
|
116
116
|
|
|
117
117
|
|
|
118
118
|
###追記
|
|
119
|
+
```
|
|
119
120
|
clearDBのMySQLサービスインスタンス内の文字コード
|
|
120
121
|
（win10コマンドプロンプト経由で確認。）
|
|
121
122
|
|
|
@@ -144,4 +145,6 @@
|
|
|
144
145
|
+------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
|
|
145
146
|
| ビュー名 | ビューの生成規則 | utf8 | utf8_general_ci |
|
|
146
147
|
+------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
|
|
147
|
-
1 row in set (0.20 sec)
|
|
148
|
+
1 row in set (0.20 sec)
|
|
149
|
+
|
|
150
|
+
```
|
1
文字コード情報を追記しました。
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -112,4 +112,36 @@
|
|
|
112
112
|
[デプロイ先]
|
|
113
113
|
PivotalCloudFoundry(Pivotal Web Services)
|
|
114
114
|
[使用DB]
|
|
115
|
-
Cleardb MySQL(CloudFoundryのサービスインスタンス)
|
|
115
|
+
Cleardb MySQL(CloudFoundryのサービスインスタンス)
|
|
116
|
+
|
|
117
|
+
|
|
118
|
+
###追記
|
|
119
|
+
clearDBのMySQLサービスインスタンス内の文字コード
|
|
120
|
+
（win10コマンドプロンプト経由で確認。）
|
|
121
|
+
|
|
122
|
+
【データベースの文字コード】
|
|
123
|
+
mysql> show create database データベース名 ;
|
|
124
|
+
+--------------------+-----------------------------------------------------------------------------+
|
|
125
|
+
| Database | Create Database |
|
|
126
|
+
+--------------------+-----------------------------------------------------------------------------+
|
|
127
|
+
| データベース名 | CREATE DATABASE `データベース名` /*!40100 DEFAULT CHARACTER SET utf8 */ |
|
|
128
|
+
+--------------------+-----------------------------------------------------------------------------+
|
|
129
|
+
1 row in set (0.19 sec)
|
|
130
|
+
|
|
131
|
+
【テーブルの文字コード】
|
|
132
|
+
mysql> show create table テーブル名;
|
|
133
|
+
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
|
134
|
+
| Table | Create Table |
|
|
135
|
+
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
|
136
|
+
| テーブル名 | CREATE TABLE `テーブル名` (カラム定義) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 |
|
|
137
|
+
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
|
138
|
+
1 row in set (0.17 sec)
|
|
139
|
+
|
|
140
|
+
【ビューの文字コード】
|
|
141
|
+
mysql> show create view ビュー名;
|
|
142
|
+
+------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
|
|
143
|
+
| View | Create View | character_set_client | collation_connection |
|
|
144
|
+
+------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
|
|
145
|
+
| ビュー名 | ビューの生成規則 | utf8 | utf8_general_ci |
|
|
146
|
+
+------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
|
|
147
|
+
1 row in set (0.20 sec)
|