PDOã§mysqlã«æ—¥æœ¬èªžã¤ã£ã“ã‚“ã ら文å—化ã‘ã—ã¦å›°ã£ãŸã‘ã©è§£æ±ºã—㟠- プãƒã‚°ãƒ©ãƒ メモPDOã§utf-8ã®æ—¥æœ¬èªžå…¥åŠ›ãƒ‡ãƒ¼ã‚¿ï¼ˆãƒ•ã‚©ãƒ¼ãƒ データ）を入れãŸã‚‰æ–‡å—化ã‘ã—ã¦ãŸï¼ˆMysql Query Borwser上ã§ï¼‰ã€‚ åŒã˜ãutf-8è¨å®šã®RubyデータãŒæ–‡å—化ã‘ã—ã¦ãªã„ã®ã§ã€mysql内ã§ã®è¨å®šã¯å•é¡Œãªã„ã¯ãšã€‚ ã„ã‚ã„ã‚ã‚„ã£ã¦ãŸã‚ã—ãŸã¨ã“ã‚ã€æ¬¡ã®æ–¹æ³•ã§ä¸€ç™ºè§£æ±ºã€‚ $pdo = new PDO("mysql:host=localhost; dbname=phptest", "root", "pass"); $stmt = $pdo -> query("SET NAMES utf8;"); $stmt = $pdo->prepare("insert into hoge(name, count)values(:name, :count)"); : $stmt = $pdo -> query("SET NAMES utf8;");ãŒé‡è¦ã€‚php.iniã«charset関係ã®è¨å®šã¯ä¸è¦
PDOã§ã‚µã‚¯ã‚µã‚¯DB開発
{{#tags}}- {{label}}
{{/tags}}