Re: Hebrew MySQL dump charset problems

[greg rashkevitch]

OK, thanks Rick.
Here is my example result:

SQL result

Host: localhost
Database: testdb
Generation Time: Oct 16, 2009 at 01:22 PM
Generated by: phpMyAdmin 3.2.0.1 / MySQL 5.1.36-community-log
SQL query: SELECT user_real_name, hex(user_real_name), length(user_real_name), char_length(user_real_name) FROM user LIMIT 0, 30 ;
Rows: 15
user_real_name hex(user_real_name) length(user_real_name) char_length(user_real_name)
עודד חיים ×‘×¨×™×™× ×¨ C397C2A2C397E280A2C397E2809CC397E2809C20C397E28094C397E284A2C397E284A2C397C29D20C397E28098C397C2A8C397E284A2C397E284A2C397C2A0C397C2A8 67 30
עודד C397C2A2C397E280A2C397E2809CC397E2809C 19 8
דקלה ××™×™×–× ×¨ C397E2809CC397C2A7C397C593C397E2809D20C397C290C397E284A2C397E284A2C397E28093C397C2A0C397C2A8 46 21
0 0
פליקס גרימברג C397C2A4C397C593C397E284A2C397C2A7C397C2A120C397E28099C397C2A8C397E284A2C397C5BEC397E28098C397C2A8C397E28099 54 25
יפעת ×‘×¨×™×™× ×¨ C397E284A2C397C2A4C397C2A2C397C2AA20C397E28098C397C2A8C397E284A2C397E284A2C397C2A0C397C2A8 45 21
0 0
גרגורי רשקביץ C397E28099C397C2A8C397E28099C397E280A2C397C2A8C397E284A220C397C2A8C397C2A9C397C2A7C397E28098C397E284A2C397C2A5 55 25
חן ×ž×’× ×¨ C397E28094C397C5B820C397C5BEC397E28099C397C2A0C397C2A8 27 13
0 0
0 0
×¢× ×‘×œ רז C397C2A2C397C2A0C397E28098C397C59320C397C2A8C397E28093 27 13
סלע רפאלי C397C2A1C397C593C397C2A220C397C2A8C397C2A4C397C290C397C593C397E284A2 34 17
שי אוחיון C397C2A9C397E284A220C397C290C397E280A2C397E28094C397E284A2C397E280A2C397C5B8 38 17
עידו C397C2A2C397E284A2C397E2809CC397E280A2 19 8

As you can see the user_real_name field is gibberished...

Thanks for the help,

Greg



Edited 1 time(s). Last edit at 10/16/2009 07:23AM by greg rashkevitch.