Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 18th March 2007, 02:34
orasis orasis is offline
Senior Member
 
Join Date: Mar 2007
Posts: 169
Thanks: 11
Thanked 9 Times in 9 Posts
Default ISPconfig Default DB Character Set for Sites

Hi, I noticed that the default character set for the databases that ISPconfig creates is "latin1_swedish_ci".

My question is, which is the file that is responsible for the default character set of the databases created by ISPconfig ?

All I need is to turn it to use "utf8_general_ci" as default.

anyhelp ? thanks alot in advance.
Reply With Quote
Sponsored Links
  #2  
Old 18th March 2007, 10:37
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,778
Thanks: 821
Thanked 5,333 Times in 4,184 Posts
Default

This is not set in a config file of ISPConfig, it si set in the my.cnf config file of your mysql installation.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 18th March 2007, 11:22
orasis orasis is offline
Senior Member
 
Join Date: Mar 2007
Posts: 169
Thanks: 11
Thanked 9 Times in 9 Posts
Default

hm yeah you are right,

.. the thing is that i found nothing in that file having to do with the character set
Reply With Quote
  #4  
Old 19th March 2007, 13:26
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

Take a look here: http://dev.mysql.com/doc/refman/5.0/...et-syntax.html
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 19th March 2007, 15:57
vogelor vogelor is offline
ISPConfig Developer
 
Join Date: Jan 2007
Location: Wernau, Germany
Posts: 219
Thanks: 42
Thanked 34 Times in 24 Posts
 
Default for anybody who want's to know

1und1 use this settings (as i can see - no guarantee )

/etc/mysql/my.cnf

Code:
[mysqld]
collation_server=utf8_general_ci
character_ser_server=utf8
__________________
Der neue Luxus heit Zeit, nicht Geld!

Firma : http://www.muv.com, http://www.computerandservice.de
Privat : http://www.vogelor.de
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ISPConfig after installation CoDonCo Installation/Configuration 46 14th July 2010 16:54
Users and websites aren't created Glorfindel Installation/Configuration 9 23rd February 2006 04:20
Default ISPconfig Page AngelDrago Installation/Configuration 15 28th October 2005 16:45
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs pontifex HOWTO-Related Questions 2 26th October 2005 17:54
ISPConfig and default web1_username meetec Installation/Configuration 1 17th October 2005 14:37


All times are GMT +2. The time now is 04:13.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.