Project

General

Profile

Bug #878

MySQL Charset

Added by bigfoot65 almost 9 years ago. Updated about 8 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
-
Target version:
-
Start date:
12/08/2011
Due date:
% Done:

100%


Description

It needs to be changed to UFT8.

History

#1 Updated by bigfoot65 almost 9 years ago

Try this in /etc/my.cnf

To set the default to UTF-8, you want to add the following to my.cnf

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
default-character-set = utf8    
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8

#2 Updated by bigfoot65 almost 9 years ago

bigfoot65 wrote:

Try this in /etc/my.cnf

To set the default to UTF-8, you want to add the following to my.cnf <br>

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
default-character-set = utf8
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8

#3 Updated by bigfoot65 almost 9 years ago

bigfoot65 wrote:

Try this in /etc/my.cnf

To set the default to UTF-8, you want to add the following to my.cnf

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
default-character-set = utf8
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8

#4 Updated by cpg almost 9 years ago

before we do this for the next release we may be able to do it in the scripts for new tables.

i remember you had a statement to be issued. that may be something we can do quick.

to format code, add a pre around it

<pre>
</pre>

#5 Updated by cpg almost 9 years ago

  • Category deleted (hda-install)
  • Status changed from New to Assigned
  • % Done changed from 0 to 50

fixed in a commit, though this only adds the utf default for new tables. let's try that, see how it works.

test rpm (for F16) in

http://alpha.amahi.org/tmp/hda-platform-6.1.16-1.noarch.rpm

#6 Updated by Anonymous about 8 years ago

  • Status changed from Assigned to Closed
  • % Done changed from 50 to 100

Applied in changeset commit:"64ce75aa73a449ae5b7b1f60a914ca198861e7e5".

Also available in: Atom