Hi

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

How do I do that?

Thanks

asked 07 Aug '13, 12:14

Lincoln%20Tang's gravatar image

Lincoln Tang
66338
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
2.1k1641
accept rate: 30%

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

Martin
8.6k116150237
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
617182435
accept rate: 6%

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

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

Question tags:

×10
×4

question asked: 07 Aug '13, 12:14

question was seen: 884 times

last updated: 19 Feb '14, 08:41