Hi I have an existing DB with Collation "1252LATIN1" and want to have it converted to "UTF8". How do I do that? Thanks |
The database collation cannot be changed without rebuilding the database file. You should unload your existing database and reload it into a new database (created with the UTF8 collation). |
In general see Mikels answer, but also consider the following regarding schema changes:
|
if you're connecting via ODBC, and want to try a simple work around before a rebuild, in your odbc settings, enter UTF-8 in the character set in the advanced tab. i THINK the UTF-8 is case-sensitive. it works for me with ASA 11. i have not tested with other versions. No UTF-8 is not case sensitive it still depends on how you create the database. So you can still choose by yourself.
(19 Feb '14, 08:41)
Martin
|