Default Collation for SMF tables

[gouri]

Hi,

I want to know default Collation for SMF Database tables.

Now they are set to latin1_swedish_ci

Is this is correct otherwise how to change back to default one.

I am thinking that the default one is utf8_general_ci

Thanks in Advance.

[Kill Em All]

Yes, you are correct, the default one is utf8_general_ci.

Atleast that is the default for me, I think it might vary by host. Don't quote me on that though.

[gouri]

Yes, you are correct, the default one is utf8_general_ci.

Atleast that is the default for me, I think it might vary by host. Don't quote me on that though.

Is there any way to change it back to normal then.

[Kill Em All]

http://www.simplemachines.org/community/index.php?topic=140917.msg1348511#msg1348511

That might be a little different in 2.0.

Make a back up of the database just in case beforehand.