Multilingual MySQL

Unicode UTF-8

International Characters in MySQL Databases

International characters can be stored in MySQL databases after version 4.1.

Using Unicode for all databases is the easiest and most universal way to achieve this is to

First, define the server collation and database encoding as utf8_bin in the database structure.

Then include the expression SET NAMES 'utf8' in the database script after the database has been selected.

Below is an example PHP script snippet.

<?php

mysql_connect (HOSTNAME, USERNAME, PASSWORD) or 
	die ('Database error: ' . mysql_error());

mysql_select_db (DATABASE);

mysql_query("set names 'utf8'");

...

?>

Web Hosts

HostGator

Globat

Links page

Privacy & Cookie Policy
Your information will never be released to any other party without your consent.
Cookies may be used on this site to customise content & enhance your visit.
Your personal information is not recorded in cookies on this site.
You cannot be identified through cookies used on this site.

Advertising sponsors on this site may gather information about your visit such as your IP address and browser type through the use of cookies or web beacons.
You can prevent this information being gathered by disabling JavaScript and cookies in your browser however your browsing experience may suffer.

Legal
Advertisements and recommendations are presented only in the capacity of referrals for services promoted on this site.
Any dispute resulting from applying for or using such services must be taken up with the vendor.

Page topic: Multilingual MySQL