Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; WP_Widget_Factory has a deprecated constructor in /home/araki/blog.ceed.jp/wp-includes/widgets.php on line 405

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Ad_Generic has a deprecated constructor in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/class-generic.php on line 10

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Ad_AdSense has a deprecated constructor in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/class-adsense.php on line 26

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Ad_AdSense_Classic has a deprecated constructor in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/class-adsense-classic.php on line 19

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Ad_AdSense_Ad has a deprecated constructor in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/class-adsense-ad.php on line 19

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Ad_AdSense_Link has a deprecated constructor in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/class-adsense-link.php on line 19

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Ad_AdSense_Referral has a deprecated constructor in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/class-adsense-referral.php on line 19

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Ad_AdBrite has a deprecated constructor in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/class-adbrite.php on line 20

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Ad_AdGridWork has a deprecated constructor in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/class-adgridwork.php on line 20

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Ad_Adpinion has a deprecated constructor in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/class-adpinion.php on line 21

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Ad_AdRoll has a deprecated constructor in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/class-adroll.php on line 21

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Ad_CJ has a deprecated constructor in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/class-cj.php on line 20

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Ad_Code has a deprecated constructor in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/class-code.php on line 19

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Ad_CrispAds has a deprecated constructor in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/class-crispads.php on line 20

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Ad_ShoppingAds has a deprecated constructor in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/class-shoppingads.php on line 20

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Ad_YPN has a deprecated constructor in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/class-ypn.php on line 20

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Ad_WidgetBucks has a deprecated constructor in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/class-widgetbucks.php on line 20

Notice: Undefined index: adsensem-show-ad in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/adsense-manager.php on line 280

Notice: wp_enqueue_script was called incorrectly. Scripts and styles should not be registered or enqueued until the wp_enqueue_scripts, admin_enqueue_scripts, or login_enqueue_scripts hooks. Please see Debugging in WordPress for more information. (This message was added in version 3.3.) in /home/araki/blog.ceed.jp/wp-includes/functions.php on line 3361

Deprecated: Non-static method adsensem::init() should not be called statically in /home/araki/blog.ceed.jp/wp-includes/plugin.php on line 470

Deprecated: Non-static method adsensem::setup_is_valid() should not be called statically in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/adsense-manager.php on line 110

Deprecated: Function create_function() is deprecated in /home/araki/blog.ceed.jp/wp-includes/pomo/translations.php on line 171

Deprecated: Non-static method adsensem::init_widgets() should not be called statically in /home/araki/blog.ceed.jp/wp-includes/plugin.php on line 470

Deprecated: Non-static method adsensem::register_widget() should not be called statically in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/adsense-manager.php on line 145

Notice: Undefined variable: args in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/adsense-manager.php on line 145

Notice: Undefined variable: _adsensem in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/adsense-manager.php on line 162

Deprecated: Non-static method adsensem::register_widget() should not be called statically in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/adsense-manager.php on line 151

Notice: Undefined variable: args in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/adsense-manager.php on line 151

Notice: Undefined variable: _adsensem in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/adsense-manager.php on line 162

Deprecated: Non-static method adsensem::register_widget() should not be called statically in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/adsense-manager.php on line 151

Notice: Undefined variable: args in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/adsense-manager.php on line 151

Notice: Undefined variable: _adsensem in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/adsense-manager.php on line 162

Deprecated: Non-static method adsensem::register_widget() should not be called statically in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/adsense-manager.php on line 151

Notice: Undefined variable: args in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/adsense-manager.php on line 151

Notice: Undefined variable: _adsensem in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/adsense-manager.php on line 162

Deprecated: Non-static method adsensem::register_widget() should not be called statically in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/adsense-manager.php on line 151

Notice: Undefined variable: args in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/adsense-manager.php on line 151

Notice: Undefined variable: _adsensem in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/adsense-manager.php on line 162

Deprecated: Non-static method adsensem::register_widget() should not be called statically in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/adsense-manager.php on line 151

Notice: Undefined variable: args in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/adsense-manager.php on line 151

Notice: Undefined variable: _adsensem in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/adsense-manager.php on line 162
MySQL | CEED
Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /home/araki/blog.ceed.jp/wp-content/plugins/ultimate_ga_1.6.0/ultimate_ga_1.6.0.php on line 524

Category Archives: MySQL

Ajax使用時の文字コード


Deprecated: Non-static method adsensem::filter_ads() should not be called statically in /home/araki/blog.ceed.jp/wp-includes/plugin.php on line 192

Deprecated: Non-static method adsensem::filter_ad_callback() should not be called statically in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/adsense-manager.php on line 198

Deprecated: Non-static method adsensem::filter_ad_callback() should not be called statically in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/adsense-manager.php on line 201

Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /home/araki/blog.ceed.jp/wp-content/plugins/ultimate_ga_1.6.0/ultimate_ga_1.6.0.php on line 524

最近ではもっぱらUTFでコーディングすることが多くなっているので、久々にEUCとか使ったスクリプトを触っていると思わぬところで躓くことがあります。Ajaxを使ってDBから値を検索し要素を置き換える、なんていう場合です。
例えば、jqueryの$.post();などはリクエスト時とレスポンス取得時に自動的に文字コードを変換してくれているようです。
リクエスト時:EUC→UTF
レスポンス取得時:UTF→EUC
なので、通常EUCを使っているアプリでも、Ajaxレスポンス用のモジュールだけは、SQLを投げる前に”SET NAMES UTF”とか明示的にUTFにして値を取得する、というようにすると文字化けが防げます。

そういえば

$.ajaxSetup(options)

なんてのもありましたね…

MySQLのテーブル破損


Deprecated: Non-static method adsensem::filter_ads() should not be called statically in /home/araki/blog.ceed.jp/wp-includes/plugin.php on line 192

Deprecated: Non-static method adsensem::filter_ad_callback() should not be called statically in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/adsense-manager.php on line 198

Deprecated: Non-static method adsensem::filter_ad_callback() should not be called statically in /home/araki/blog.ceed.jp/wp-content/plugins/adsense-manager/adsense-manager.php on line 201

Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /home/araki/blog.ceed.jp/wp-content/plugins/ultimate_ga_1.6.0/ultimate_ga_1.6.0.php on line 524

Notice: Array to string conversion in /home/araki/blog.ceed.jp/wp-content/plugins/ultimate_ga_1.6.0/ultimate_ga_1.6.0.php on line 701

MySQLを使っていて時々”#1146 - Table 'hoge_tabele' doesn't exist”なんて言われてしまう事があります。

もちろん存在しないはずはなくて、テーブルを構成しているファイルが何らかのきっかけで壊れてしまっている。
そんな時は、repair table 構文です。http://dev.mysql.com/doc/refman/4.1/ja/repair-table.html
repair table hoge_table;
ただ、これでも直らないケースがたまにあるようで、その場合スキーマ自体を削除しようとしても、そのテーブルがネックになって削除できません。うーん、、、


Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /home/araki/blog.ceed.jp/wp-content/plugins/ultimate_ga_1.6.0/ultimate_ga_1.6.0.php on line 524

Deprecated: Non-static method adsensem::footer() should not be called statically in /home/araki/blog.ceed.jp/wp-includes/plugin.php on line 470
getting health insurance in new york buy clomid online UK major health insurance companies buy levitra uk online what are wells fargo hours buy finasteride affordable health insurance for children accutane no prescription medical center of trinity viagra online uten resept midwestern university wellness center dapoxetine top individual health insurance companies viagra ireland

Warning: Use of undefined constant user_level - assumed 'user_level' (this will throw an Error in a future version of PHP) in /home/araki/blog.ceed.jp/wp-content/plugins/ultimate_ga_1.6.0/ultimate_ga_1.6.0.php on line 524