Previous Thread
Next Thread
Print Thread
Hop To
Some characters turned into gibberish
#252647 04/17/2013 3:52 PM
Joined: Nov 2008
Posts: 28
sw55 Offline OP
newbie
OP Offline
newbie
Joined: Nov 2008
Posts: 28
Hi,

I renewed my license and installed version 7. I then imported my data from UBB.threads 6.5.5 using the importer from the member download area. I found it very straight forward.

Except for this problem: all of the 'non-English' characters (and some other characters like trademark symbols, some quotation marks etc.), turned into 'gibberish'. For example, my Korean forum title is like this: 歡迎使用 Ÿä»¶ï¼

When I do a mysqldump of my 6.5.5 forum and view the .sql in notepad++ everything looks good. I remember having a similar problem when I went from MySQL 4 to 5 and had to export and import the forum, but I'm not certain what the fix for that problem ended up being. I think I set something to 'latin' in the exported sql file.

Anyone know what's going on and how it can be fixed?

Thanks,
Andrew

Re: Some characters turned into gibberish
sw55 #252648 04/17/2013 4:39 PM
Joined: Dec 2003
Posts: 6,144
Likes: 21
Offline
Joined: Dec 2003
Posts: 6,144
Likes: 21
I am by no means a expert on this issue but it probably has to do with the character set used before the upgrade and after.
This impacts the way the data strings are stored in the dbase.
The older versions used character set ISO-8859-?.
The newer versions used character set utf8 .
This was a option seen only when installing the newer versions not upgrading.
When upgrading you needed to do some edits to the script.

Do a search for both terms ISO-8859 and utf8
Another search term would be non-latin characters. This s probably what you recall.

Last edited by Ruben; 04/17/2013 4:43 PM.

Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: Some characters turned into gibberish
sw55 #252649 04/17/2013 4:53 PM
Joined: Jun 2006
Posts: 15,939
Likes: 27
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,939
Likes: 27
As Ruben said, you'll need to update the charset in the language files (I think it's in Generic) to whatever you where using before; Korean characters aren't a part of the Latin Character Set so it'll end up gibberish.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, I Find Rocks, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Some characters turned into gibberish
sw55 #252650 04/17/2013 5:14 PM
Joined: Dec 2003
Posts: 6,144
Likes: 21
Offline
Joined: Dec 2003
Posts: 6,144
Likes: 21
A quick look shows me it is in the language files.
Languages/English/Generic.php
Key CHARSET
I have iso-8859-1 for version 7.5.6
If you have a backup from your older version you probably will find it is like utf-8

Of course if you have a different language pack installed you will need to edit the field in that folder


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: Some characters turned into gibberish
sw55 #252651 04/17/2013 5:31 PM
Joined: Dec 2003
Posts: 6,144
Likes: 21
Offline
Joined: Dec 2003
Posts: 6,144
Likes: 21
Curious thought why did you stop at 7.1 for a upgrade?
Or was this just the first upgrade step?


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: Some characters turned into gibberish
Ruben #252652 04/17/2013 5:47 PM
Joined: Nov 2008
Posts: 28
sw55 Offline OP
newbie
OP Offline
newbie
Joined: Nov 2008
Posts: 28
Hi,

Quote
A quick look shows me it is in the language files.
Languages/English/Generic.php
Key CHARSET
I have iso-8859-1 for version 7.5.6
If you have a backup from your older version you probably will find it is like utf-8

Thanks very much your quick replies - that absolutely worked! My old files were set to utf-8, and setting the new one to utf-8 solved it.

Regarding 7.1. Actually I have 7.5.7.

What I said was "I installed version 7 [period][new sentence] I then imported my data..." smile

Re: Some characters turned into gibberish
sw55 #252653 04/17/2013 5:48 PM
Joined: Dec 2003
Posts: 6,144
Likes: 21
Offline
Joined: Dec 2003
Posts: 6,144
Likes: 21
Otay. Good deal.
I guess I guessed correctly! lol


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: Some characters turned into gibberish
sw55 #261917 12/16/2018 6:15 AM
Joined: Jun 2006
Posts: 956
Old Hand
Offline
Old Hand
Joined: Jun 2006
Posts: 956
I knew its a old thread but I run in the same problem. Its not only the change of the language string in generic.php. This may help at the frst view but take a closer look to your database tables. I write a longer text about this here: https://www.ubbcentral.com/forums/u...coding-utf-8-and-older-forums#Post261912


my board: http://www.dragonclan-forum.de
my hobby: http://www.biker-reise.de
Ich kann bei Fragen zu UBBthreads in Deutsch weiterhelfen oder es zumindest versuchen

Link Copied to Clipboard
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Non-Admin users can't see attached pictures
by jjjjj - 07/11/2020 8:09 PM
[NOTABUG] Report Post bug..
by Morgan - 07/05/2020 1:48 PM
Trial Subscription question.
by Ruben - 07/03/2020 2:34 PM
Unread posts no longer tracked per user...
by KirkW - 06/16/2020 12:21 AM
Max Image file size upload
by jjjjj - 06/10/2020 10:25 PM
Who's Online Now
1 members (Ruben), 90 guests, and 46 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4