Koozali.org: home of the SME Server

Obsolete Releases => SME Server 7.x => Topic started by: AlexG on June 04, 2009, 05:51:08 AM

Title: locale encoding on SME
Post by: AlexG on June 04, 2009, 05:51:08 AM

Hi Forum

How do I set the locale encoding from latin1_swedish_ci to utf-8 on SME 7.4 ?

Title: Re: locale encoding on SME
Post by: Franco on June 07, 2009, 05:17:08 PM

Is this a html or mysql encoding?
If it's mysql, then you can use the PHPmyadmin contrib and set per database.

Title: Re: locale encoding on SME
Post by: cactus on June 07, 2009, 10:07:29 PM

Quote from: Franco (a.k.a. stuntshell) on June 07, 2009, 05:17:08 PM

If it's mysql, then you can use the PHPmyadmin contrib and set per database.

Or use the alter table syntax from the MySQL manual: http://dev.mysql.com/doc/refman/4.1/en/alter-table.html (http://dev.mysql.com/doc/refman/4.1/en/alter-table.html), as that would save them installing a (additional) contrib.

Keep in mind that login in on SME Server to MySQL is a little different: http://wiki.contribs.org/MySQL#Login_as_MySQL_root_user