How to convert a 1252LATIN1 DB to UTF8 DB?

2	Hi I have an existing DB with Collation "1252LATIN1" and want to have it converted to "UTF8". How do I do that? Thanks utf8 convert asked 07 Aug '13, 12:14 Lincoln Tang 66●3●3●8 accept rate: 0% flat view

3 Answers:

active answers oldest answers newest answers popular answers

2	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). permanent link answered 07 Aug '13, 12:47 Mikel Rychliski 2.1k●16●41 accept rate: 32% flat view

In general see Mikels answer, but also consider the following regarding schema changes:

Change the length of all VARCHAR or CHAR columns to have an explicit character-length semantics, beware CHAR columns will use 4 times more bytes doing so.
Check all columns having an explicit INLINE or PREFIX clause, because these have their length allways in bytes, so in the worst case a PREFIX of 8 might be only 2 chars.

permanent link

answered 19 Feb '14, 08:39

Martin
9.0k●130●169●257
accept rate: 14%

flat view

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.

permanent link

answered 12 Aug '13, 11:16

Tom Mangano
672●24●27●38
accept rate: 8%

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

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

utf8 ×14
convert ×9

question asked: 07 Aug '13, 12:14

question was seen: 2,901 times

last updated: 19 Feb '14, 08:41

SAP SQL Anywhere

How to convert a 1252LATIN1 DB to UTF8 DB?

Follow this question

Related questions