News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

How to convert from Windows-1250 to UTF-8

Started by Excalibur!, December 03, 2007, 05:33:26 PM

Previous topic - Next topic

Excalibur!

Is there any solution for converting from Windows-1250 to UTF-8?

jerm

Forum Maintenance

You can convert through forum maintenance

Does that answer your question? Its pretty vague.

Excalibur!

Actually, I can't. Windows-1250 is not supported...
I heard something about dumping my DB and then convert it with TextPipe or Notepad2, but I don't know anything about it...

jerm

I have contacted a support member who knows more about conversions. Hopefully he will be able to get in touch with you soon to resolve this issue.

Sarge


    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

Excalibur!

Hmm, I can not access this topic... I have no rights...

Excalibur!

After all, I found that I can dump my DB, then open in some advanced text editor like EmEditor, Notepad2 or UniRed, select all text, change coding to UTF-8 and then paste into it and finally save. I import edited DB and that's all, but I still have no success... When I open some tables in phpmyadmin there is no change with special characters...

Sarge

Sorry about that...

In Sources/Admin.php, find:
// Russian.
'windows-1251' => 'cp1251',


Add before that:
// Central European
'windows-1250' => 'cp1250',



    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

Excalibur!

I can see the point... :)
OK, I did it! Now I can try to convert the DB through the CP?

Sarge

Quote from: Excalibur! on December 05, 2007, 04:12:57 PM
I can see the point... :)
OK, I did it! Now I can try to convert the DB through the CP?

Yes, but make a database backup first.

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

Excalibur!


Sarge


    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

Excalibur!

Nothing... :( I still can't get special characters... This conversion through CP everything mess up... I will try again...

Sarge

Quote from: Excalibur! on December 06, 2007, 01:41:43 AM
Nothing... :( I still can't get special characters... This conversion through CP everything mess up... I will try again...

SMF, PHP and MySQL versions? You can get this info from SMF Admin > Support and Credits > Version Information section.

Which special characters are not converted correctly? Just a few, or all of them?

Can you send me a copy of your database via PM, so that I can take a look? Perhaps a new table is needed for win1250 in Admin.php.

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

Sarge

Forgot to ask, did you install and use a -utf8 language pack on your forum after the conversion?

Also, have you selected "UTF-8 (Unicode)" from the View menu --> Character Encoding (in Firefox) or View --> Encoding (in Internet Explorer)?

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

Excalibur!

My test server Apache/2.0.53:

SMF 1.1.4
PHP 4.3.9
MySQL 4.1.20

My original server Microsoft-IIS/6.0:

SMF 1.1.4
PHP 5.2.1
MySQL 5.0.22

All of special characters are not converted correctly...
I'll send you a copy...

Quote from: Sarge on December 06, 2007, 02:18:48 AM
Forgot to ask, did you install and use a -utf8 language pack on your forum after the conversion?

Also, have you selected "UTF-8 (Unicode)" from the View menu --> Character Encoding (in Firefox) or View --> Encoding (in Internet Explorer)?

I did it all actions...

Excalibur!

After some time Sarge found that my database had "duplicate indexes" in smf_log_search_results, smf_log_search_subjects and smf_log_topics, so the conversion to UTF-8 couldn't complete. He edited tables and gave me full detailed instructions what to do...

What can I say...? I am endlessly grateful!!! :)

Sarge

#17
Great to know the conversion is done successfully now!

I'll mark this topic as solved. Let us know if you need more help with this. ;)

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

Excalibur!


Sarge


    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

Advertisement: