News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Convert the database and data to UTF-8

Started by nick_n_ii, January 31, 2011, 01:31:49 PM

Previous topic - Next topic

nick_n_ii

It says this in red:

Your messages table is using a fulltext index for use when searching. You cannot proceed in converting to UTF-8 until that index is removed. You can re-create it after the conversion has been completed.

How, why and where do I turn this off than back on again?
www.adv4x4s.com
SMF 2.0.2
SimplePortal 2.3.5

Arantor

Admin > Posts and Topics > Search

You'll see in there that the search method is using Fulltext and that it's listing a fulltext index, where there is a remove index option.

nick_n_ii

OK thanks..


Can Convert the database and data to UTF-8 cause any issues?  Is it something I should do?
www.adv4x4s.com
SMF 2.0.2
SimplePortal 2.3.5

Arantor

Firstly, BACK UP.

It's only necessary if your forum is based around a non English language. If your forum uses English, or at least no accented characters, it's not necessary.

If you are using different languages, it is a very good idea to use UTF-8.

nick_n_ii

OK well My site is based around English so I should be fine than...
www.adv4x4s.com
SMF 2.0.2
SimplePortal 2.3.5

Advertisement: