ブラウザの文字コード UTF-8
mysql> status ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Server characterset: latin1 Db characterset: utf8 Client characterset: latin1 Conn. characterset: latin1 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
エラーがなく通るも、画面上で文字化け
mysql> charset utf8 mysql> status ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Server characterset: latin1 Db characterset: utf8 Client characterset: utf8 Conn. characterset: utf8 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
プロシージャ実行中にエラー
ERROR 1366 (HY000): Incorrect string value: 'xxxxxxxxx' for column 'xxxxxxxx' at row xx
mysql> SET character_set_client = sjis; mysql> status ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Server characterset: latin1 Db characterset: utf8 Client characterset: sjis Conn. characterset: latin1 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
エラーなく通るも、画面上で文字化け
mysql> SET character_set_client = sjis; mysql> SET character_set_connection = utf8; mysql> status ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Server characterset: latin1 Db characterset: utf8 Client characterset: sjis Conn. characterset: utf8 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
問題なく通る
0 件のコメント:
コメントを投稿