php-pdoGet current charset with PHP PDO
$charset = $pdo->query("SELECT COLLATION('')")->fetchColumn();ctrl + c$pdoPDO connection object | query(executes specified SQL and return |
SELECT COLLATION('')will return current charset (actually collation, but that's also ok for this task) | $charsetwill contain current charset (collation) |
Usage example
<?php
$pdo = new PDO('mysql:host=localhost;dbname=test', 'usr', 'pwd');
echo $pdo->query("SELECT COLLATION('')")->fetchColumn();output
utf8mb4_general_ciMore of Php Pdo
- How to install PHP PDO for Mysql in Ubuntu 22.04
- Bind current datetime with PHP PDO
- Get current database name with PHP PDO
- Fetch single column value with PHP PDO
- Set execution timeout with PHP PDO
- Connect to MariaDB using PHP PDO
- Connect to Mysql with PHP PDO
- How to bind table name in PHP PDO
- How to get results after PHP PDO statement execute()
- Escape string with PHP PDO
See more codes...