Search  
   
Browse by Category
 
Netfirms 24/7 Support .: DATABASE MANAGEMENT .: What language or character sets does MySQL support?

What language or character sets does MySQL support?

To determine what mysql language (eg. character sets) are supported in MySQL, follow these instructions:

1. Login to the Netfirms Control Panel at https://controlpanel.netfirms.com
2. Click Site Tools
3. Click Database Manager
4. For the database you wish to administer (click Add if you have not created one yet), click Admin
5. Click phpMyAdmin
6. Click your database id (eg. looks something similar to d60596867)
7. Click SQL
8. Enter the following query:

SHOW CHARACTER SET;

9. Click Go to run the query

The above query will return the list of languages/character sets supported in MySQL.

Example:

Below is an example of how to create table using the greek character set

Create table Mytable (
[colu] char(10) COLLATE Greek_CI_AS NULL,
[Maydate] [char] (8) COLLATE Greek_CI_AS NOT NULL ,
[Risk_Rating] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
)

This must be applied to tables before data is imported and cannot be applied retroactively.

NOTE: To change the character set, click here.


How helpful was this article to you?


.: Powered by Lore 1.5.6
Visit Netfirms.com Web Hosting | Copyright © 1998 - 2006 Netfirms, Inc. All Rights Reserved.