The forum will be down for maintenance over the weekend of August 18-20, 2017. The forum will be shut down on the evening (EDT) of Friday, August 18. Downtime is unknown but may be up to two days. The forum will be restarted as soon as maintenance is complete.

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.6k117151237
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
632192536
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: 959 times

last updated: 19 Feb '14, 08:41