MyBB Community Forums

Full Version: mysql tables Collocation format
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
this is an image of my db sql table in "phpmyadmin"

[Image: sda.JPG]


the Collation format is "utf8_general_ci" for all tables
and the sum collocation is "latin1_general_ci"

do I have to change the format of the table to another utf-8 ?
in the list there is ut8-general and utf-8 unicoded ?
because i'm using arabic language in my forum and this always causes problems especially when I restore a backup ..

and how can I change the tables sum from "latin1_general_ci" to another ?

thanks in advance ..
Run this in phpMyAdmin SQL:

ALTER DATABASE `mybb` DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci

Rename the mybb part to the name of your database to change the collation.