Japanese data turns to ??? in backed up UTF8 sql | Old Forum | Forum Archive

The free forums are no longer in use. It remains available as read-only archive.

Avatar
sp_LogInOut Log In
Lost password?
sp_Search Search
Advanced Search
Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
Go to Bottom
The forums are currently locked and only available for read only access
sp_TopicIcon
Japanese data turns to ??? in backed up UTF8 sql
November 15, 2008
12:00 am
Avatar
boyjah
Guest
Guests
Go to Top
1sp_Permalink sp_Print

I have successfully backed up my sql database file, sent it to another server and restored it. However, in the restored file the Japanese text has become just a bunch of question marks.

I have specified UTF8 as data format every place that I can find to make such a designation.

Does anybody have experience with this kind of problem?

The site is in English and Japanese and I am using XCloner and Joomla 1.5.6

November 15, 2008
12:00 am
Avatar
admin
Guest
Guests
Go to Top
2sp_Permalink sp_Print

HI there! I am not sure what encoding you have for the japanese characters, have you tried restoring with the latin1 or latin2 character set enabled? Make sure that your restore mysql server also supports these types of encoding

If you still have issues, please open a support ticket to help you! Regards, Ovidiu

sp_Feed All RSS
Go to top
Forum Timezone: America/Chicago
Most Users Ever Online: 867
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
mlguru: 30
Django29: 29
D: 21
Andy: 21
Marcus: 20
Jamie F: 19
Member Stats:
Guest Posters: 738
Members: 10048
Moderators: 2
Admins: 3
Forum Stats:
Groups: 3
Forums: 7
Topics: 2397
Posts: 8236
Newest Members:
Omar Vera
Moderators: TriP: 0, Steve Burge: 0
Administrators: Ovidiu Liuta: 2484, Victor Drover: 1, Valentin Barbu: 0