HI! Team,
I am quite new to MYSQL, i am trying to setup a DB and in few table with a japanese character, when i just copied the japanese characters and inserted, when i looked that into the database it all looks like ?????. I have changed all the collation propertied and chanracter properties to utf8 here is how it looks
+----------------------+-------------------+ | Variable_name | Value | +----------------------+-------------------+ | collation_connection | latin1_swedish_ci | | collation_database | utf8_general_ci | | collation_server | utf8_general_ci | +----------------------+-------------------+ 3 rows in set (0.00 sec)
+--------------------------+---------------------- --------+ | Variable_name | Value | +--------------------------+---------------------- --------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | charachter_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | c:\Program Files\MySQL\MySQL Server 5.1\share\charsets | +--------------------------+---------------------- --------+ 8 rows in set (0.00 sec)
mysql> show tables; +----------------+ | Tables_in_test | +----------------+ | t1 | +----------------+ 1 row in set (0.00 sec)
mysql> select c1, hex(c1) from t1; +-------+---------+ | c1 | hex(c1) | +-------+---------+ | a | 61 | | A | 41 | | ‚À | 82C0 | +-------+---------+ 3 rows in set (0.00 sec)
how can i see the japanese characters, is there anything am i doing wrong, please advise...how can i get displayed the chinese character in the DB
Thank you for you help much appreciated...