SMF Support > Install and Upgrade Help

Upgrade from SMF 1.1.16 to SMF 2.0.2 - language/character problem.

<< < (2/2)

Illori:
we are all volunteers so maybe those that know the answer were busy elsewhere and could not get to reply to your thread.

also you really should not bump within 24 hours.

wildd:
Ok, thanks for help. I figured out that there had been some bug with SMF 1.1.16 and although my DB was set as UTF-8, the data was inserted (SMF?) in latin1 or latin2.

So the problem is that I have UTF-8 tables and columns and data what is encoded in UTF-8, but before insertion it was encoded in some other encoding.

I find solution for this and it almost worked and I was so happy, but steel some things like topic titles remained messed with "?"

--- Quote ---UPDATE smf_messages SET subject=CONVERT(CONVERT(CONVERT(subject USING 'latin1') USING BINARY) USING 'utf8')
--- End quote ---

Executing this on topic posts columns, private message columns, board name and description columns worked fine, but as I said, topic titles are still with "?", which makes me think that maybe they were encoded not in latin1 but maybe latin2 or something else.

In which SMF 1.1.16 PHP files I need to look to find out in what topic titles were encoded before inserting in DB?

JimM:
Not sure if it is of any help but my collation in a non-utf8 install is latin1_swedish_ci. 

Crazy F:
I'm not able to update from 1.1.16 to 2.0.2. The upgrade always stop when it goes to update the DB. Can it be because of this settings???

$language = 'english';      # The default language file set for the forum.
$db_character_set = 'utf8';

What should I do to fix this?

Thanks in advance for any help!

Navigation

[0] Message Index

[*] Previous page