"PHP PDO PostgreSQL UTF-8 설정"의 두 판 사이의 차이

2020년 11월 2일 (월) 02:56 기준 최신판

1 개요[ | ]

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'");

2 같이 보기[ | ]

PDO
DSN

3 참고[ | ]

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

@@ 2번째 줄: / 2번째 줄: @@
 ;PHP PDO PostgreSQL UTF-8 설정
-<source lang='php'>
+<syntaxhighlight lang='php'>
 $driver = 'pgsql';
 $host = 'localhost';
@@ 9번째 줄: / 9번째 줄: @@
 $user = 'testuser';
 $passwd = 'P@ssw0rd';
+$dsn = "$driver:host=$host;port=$port;dbname=$dbname";
-$pdo = new PDO("$driver:host=$host;port=$port;dbname=$dbname", $user,  $passwd);
+$pdo = new PDO($dsn, $user, $passwd);
 $pdo->exec("SET CLIENT_ENCODING TO 'utf8'");
 // $pdo->exec("SET NAMES 'utf8'");
-</source>
+</syntaxhighlight>
 ==같이 보기==
 *[[PDO]]
+*[[DSN]]
-==참고 자료==
+==참고==
 *http://stackoverflow.com/questions/18250167/how-set-utf-8-in-pdo-class-constructor-for-php-pgsql-database