Koozali.org: home of the SME Server

locale encoding on SME

Offline AlexG

  • ****
  • 110
  • +0/-0
locale encoding on SME
« 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 ?

Offline Franco

  • *
  • 1,171
  • +0/-0
    • http://contribs.org
Re: locale encoding on SME
« Reply #1 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.

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: locale encoding on SME
« Reply #2 on: June 07, 2009, 10:07:29 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, 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
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)