This is a migrated thread and some comments may be shown as answers.

How to specify MySql Collation??

1 Answer 61 Views
Databases and Data Types
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Brian
Top achievements
Rank 1
Brian asked on 29 Jul 2010, 05:12 AM
Hi, 

In the table creation of MySql, openaccess creates tables in "Latin" collation, but that is not I want. I want to use "UTF-8" as default. Is there any way to do so??

John

1 Answer, 1 is accepted

Sort by
0
Thomas
Telerik team
answered on 29 Jul 2010, 08:20 AM
Hi Ming Jen Huang / John,

at the moment there is only one option, and that is to create the empty database (manually, not by OpenAccess) in such a way that your preferred encoding and collation is the default for the database.
Because OpenAccess currently does not specify encoding/collation at a column or table level, the defaults from the database are used.
I will file a feature request to support table and column collation/encodings.

Regards,
Thomas
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Tags
Databases and Data Types
Asked by
Brian
Top achievements
Rank 1
Answers by
Thomas
Telerik team
Share this question
or