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:
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.