The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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.6k114149237
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
587182334
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: 814 times

last updated: 19 Feb '14, 08:41