storing utf8 data into latin1 database if i have database named TESTDB and i'm storing utf8 data into this
latin1 TESTDB database is there a way that i can convert database to
utf8?
what happens with utf8 data when it is stored into latin1 database?
is there any way i can get original data?
server/database info:
mysql> use TESTDB;
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)
mysql> show create database TESTDB;
+--------------
+-------------------------------------------------------------------------
+
| Database | Create
Database |
+--------------
+-------------------------------------------------------------------------
+
| TESTDB | CREATE DATABASE `TESTDB` /*!40100 DEFAULT CHARACTER SET
latin1 */ |
+--------------
+-------------------------------------------------------------------------
+
1 row in set (0.00 sec)
Server version: 5.0.22
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1 |