Upgrade from 1.1.16 to 2.0.2 problem

[9A6DQB]

Hello. I have upgraded SMF from 1.1.16 version to 2.0.2 and upgrade gone well without any problem. When it came up to the last step (to delete upgrade.php) and when it redirects me to the forum root, this error showed up:

Unknown character set: 'windows'

Only blank page and that error. Default forum language was English, utf-8 and it had some balkanian language characters such as ćčžđš.

What should I do now ?
www. diabetes.hr/Forum [nofollow]

I read last posts from topis upgerase 1.1.10 to 2.0, but did not find answer.

Language is: croatian
phpinfo.php is on.

Thanks in advance for any support.

[kat]

Hello. I have upgraded SMF from 1.10 version to 2.0 RC2

Why not restore your backup and start again, upgrading to v2.0.2?

RC2 was, in effect, a beta version, after all...

[9A6DQB]

My bad!
I was upgrade from 1.1.16 to 2.0.2.
Not RC

[kat]

Looks like this guy had the same problem.

http://www.simplemachines.org/community/index.php?topic=351080.0

Would the solution, there, work for you?

[9A6DQB]

Unfortunatly no.
I tryed it, but still ne go!

Language is croatian, and cp is windows 1250.
Cp of database is latin1.swidish.cp

[kat]

So, what does the line with "$db_character_set = ", in settings.php, say, on yours?

[9A6DQB]

$db_character_set = 'windows-1250';

This because I am also using croatian chars like ŠĐĆČ...
On old one 1.1.16 works fine...

[kat]

Did you try changing it to:

$db_character_set = 'utf8';

[9A6DQB]

Ofcourse...not! 

Now forum is back online, but I do not have croatian specific chars.
Ĺ˝ivot  should be Život...

All data is now wrong coded...

[kat]

Hmmm... It looks like the script is seeing "windows" but not the "-1250" and I can't think why...

Let me do some research.

Gimme a while.

[kat]

Well, I'm non-the-wiser.

If your forum is using UTF-8, it seems that $db_character_set = 'utf8'; should work.

Is your forum not set for UTF-8?

What makes things even more curious, is that I just checked my own Settings.php file and I don't even have a "$db_character_set =" entry.

The nearest I can see is $language = 'english_british'; and that looks like it doesn't affect the database.

So, I have to say, I'm totally at a loss.

Sorry an' all that.

[9A6DQB]

In forum admin, i have option to convert database to UTF8.
Should this resolve my problem?

Or I should change every specific char with croatian char, in database?
Should be some sql code to do it, rather then do it manualy?

[Matthew K.]

Try converting the database to UTF-8.

[9A6DQB]

Well, there is a problem.
My old coding is windows-1250.
In admin panel there is not windows 1250 to utf.
Only 1251(Russian?), 1252 ...

[9A6DQB]

I just return backup DB
when I access my forum, in info there is text/html; charset=windows-1250
How to convert to UTF8, without loosing croatian special chars?
If i try to convert from admin panel SMF, i lost all spec chars, probably because there is no option to convert Windows-1250, only 1251,1252...

[9A6DQB]

Still didnt resolved my problem!

How could I change charset that is presented to world?
When I am looking for page information, still got windows 1250 coding, not UTF...
Where can I change this?

[NanoSector]

Are you using the UTF-8 version of the Croatian language?

[9A6DQB]

Yes. I am using croatian utf8, with no luck.
Also if i try to use croatian, not utf, the same is. I lost all my special croatian chars.

[9A6DQB]

We converted DB to utf8.
But now i got message: Unknown column 'a.attachment_type' in 'field list'

I did tryed script repair_settings.php with no luck!

Any sugestions, please!
Thanks