|
|
Joined: Nov 2008
Posts: 39
Newbie
|
Newbie
Joined: Nov 2008
Posts: 39 |
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
|
|
|
|
Joined: Dec 2003
Posts: 6,562 Likes: 78
|
Joined: Dec 2003
Posts: 6,562 Likes: 78 |
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
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
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.
|
|
|
|
Joined: Dec 2003
Posts: 6,562 Likes: 78
|
Joined: Dec 2003
Posts: 6,562 Likes: 78 |
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
|
|
|
|
Joined: Dec 2003
Posts: 6,562 Likes: 78
|
Joined: Dec 2003
Posts: 6,562 Likes: 78 |
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
|
|
|
|
Joined: Nov 2008
Posts: 39
Newbie
|
Newbie
Joined: Nov 2008
Posts: 39 |
Hi, 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..."
|
|
|
|
Joined: Dec 2003
Posts: 6,562 Likes: 78
|
Joined: Dec 2003
Posts: 6,562 Likes: 78 |
Otay. Good deal. I guess I guessed correctly! lol
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
|
2 members (Nightcrawler, Ruben),
694
guests, and
214
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|
|