Member Avatar for davy_yg

Anyone knows how to enable Database UTF-8 Support?

Database UTF-8

  • 2 Contributors
  • 1 Reply
  • 103 Views
  • 4 Hours Discussion Span
  • Latest Post Latest Post by sinhaksaurabh
Member Avatar for sinhaksaurabh

To enable UTF8 support in server level:

1. First create a backup for file /etc/mysql/my.ini

2. Open /etc/mysql/my.ini file for editing

3. Locate [mysql] and [mysqld] and append the following lines:

[mysql]
default-character-set=utf8

[mysqld]
collation_server=utf8_unicode_ci
character_set_server=utf8
default-character-set=utf8
init_connect=’SET collation_connection = utf8_general_ci’
init_connect=’SET NAMES utf8′

4. Restart mysql

To enable UTF8 support in database level:

DATABASE [database_name] DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
Edited by sinhaksaurabh because: complete information
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.