SQL|בדיקת קידוד המסד,פונקציות לא מובנות.

[SDF]

1.

mysql> CREATE DATABASE derey22 CHARACTER SET latin1 COLLATE latin1_swedish_ci;
Query OK, 1 row affected (0.00 sec)

mysql> use derey22;
Database changed
mysql> show variables like "character_set_database";
+------------------------+--------+
| Variable_name          | Value  |
+------------------------+--------+
| character_set_database | latin1 |
+------------------------+--------+
1 row in set (0.00 sec)

mysql> show variables like "collation_database";
+--------------------+-------------------+
| Variable_name      | Value             |
+--------------------+-------------------+
| collation_database | latin1_swedish_ci |
+--------------------+-------------------+
1 row in set (0.00 sec)

2. מה?

3. אם אתה רוצה לגבות, השתמש ב mysqldump, הכי טוב, הכי פשוט.