The forum is currently being migrated to a new host. While the migration happens, the old server is still available. Once the new machine is ready, I will copy the database to the new machine. Feel free to ask and answer questions in the meantime.

The Help says this...

Collations In version 9 and earlier, SQL Anywhere supported one collation used with CHAR data types. This collation used the SQL Anywhere Collation Algorithm (SACA). In version 10 and later, SQL Anywhere supports two collation algorithms, SACA and UCA (Unicode Collation Algorithm). Unless you specify a new or different collation for the rebuilt database, the SACA collation from the old database is unloaded and reused in the rebuilt database. http://dcx.sybase.com/index.html#1201/en/sachanges/unloading-reloading-upgrading-newjasper.html

Is it possible to specify UCA for the new database when using dbunload in a single step (internal unload)?

asked 12 Apr '11, 12:12

Breck%20Carter's gravatar image

Breck Carter
31.3k5036891010
accept rate: 20%


I guess you would have to create a new database with the according collation first and then use dbunload -ac to do an one-step unload into the newly created database.

permanent link

answered 12 Apr '11, 12:47

Volker%20Barth's gravatar image

Volker Barth
37.1k343509770
accept rate: 34%

13 Apr '11, 14:46

As Volker noted, you need to create the database first and then use dbunload -ac. On Windows, it will use an OS named piped to transfer table data between the V9 engine and the V12 engine.

permanent link

answered 13 Apr '11, 14:13

John%20Smirnios's gravatar image

John Smirnios
10.7k392141
accept rate: 38%

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:

×51

question asked: 12 Apr '11, 12:12

question was seen: 1,537 times

last updated: 13 Apr '11, 14:46