View Single Post

   
  #1 (permalink)  
Old 03-17-2008, 06:13 AM
Aljosa Mohorovic
 
Posts: n/a
Default 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
Reply With Quote