Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.


I have an existing DB with Collation "1252LATIN1" and want to have it converted to "UTF8".

How do I do that?


asked 07 Aug '13, 12:14

Lincoln%20Tang's gravatar image

Lincoln Tang
accept rate: 0%

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%20Rychliski's gravatar image

Mikel Rychliski
accept rate: 32%

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

  1. 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.
  2. 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's gravatar image

accept rate: 14%

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%20Mangano's gravatar image

Tom Mangano
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
Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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

Question tags:


question asked: 07 Aug '13, 12:14

question was seen: 2,990 times

last updated: 19 Feb '14, 08:41