changing default global encoding

This is a discussion on changing default global encoding within the MySQL Database forums, part of the Database Forums category; OS X 10.4.8 / MSQL 5.0 I would like to change the default global encodings of my db ...


Go Back   Usenet Forums > Database Forums > MySQL Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 11-03-2006
Josselin
 
Posts: n/a
Default changing default global encoding

OS X 10.4.8 / MSQL 5.0

I would like to change the default global encodings of my db to utf-8
everiwhere

presently I have :

character set client utf8
(Valeur globale) latin1
character set connection utf8
(Valeur globale) latin1
character set database latin1
character set filesystem binary
character set results utf8
(Valeur globale) latin1
character set server latin1
character set system utf8
character sets
dir /usr/local/mysql-standard-5.0.27-osx10.4-powerpc/share/mysql/charsets/
collation

connection utf8_unicode_ci
(Valeur globale) latin1_swedish_ci
collation database latin1_swedish_ci
collation server latin1_swedish_ci



If I write the following in my.conf will it be correct ?

[mysqld]
character_set_client=utf8
character_set_connection=utf8
character_set_database=utf8
character_set_results=utf8
character_set_server=utf8
collation_connection=utf8
collation_database=utf8
collation_server=utf8

thansk for your help

Reply With Quote
Reply


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

vB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:24 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0