PHP PDO PostgreSQL UTF-8 설정

개요

PHP PDO PostgreSQL UTF-8 설정

$driver = 'pgsql';
$host = 'localhost';
$port = '5432';
$dbname = 'mydb';
$user = 'testuser';
$passwd = 'P@ssw0rd';
$dsn = "$driver:host=$host;port=$port;dbname=$dbname";

$pdo = new PDO($dsn, $user, $passwd);
$pdo->exec("SET CLIENT_ENCODING TO 'utf8'");
// $pdo->exec("SET NAMES 'utf8'");

같이 보기

• PDO
• DSN

참고

• http://stackoverflow.com/questions/18250167/how-set-utf-8-in-pdo-class-constructor-for-php-pgsql-database