I am running ElevateDB Manager Unicode.
I migrate a DBISAM 4 database to ElevateDB.

When I look at the SQL tab within the ElevateDB Manager Unicode there
are some Collate definitions.

They are like :-
   "Subject" VARCHAR(30) COLLATE "ENU",

I would have expected them to become like :-
   "Subject" VARCHAR(30) COLLATE "UNI",


To check what Collate was available I ran :-
  SELECT * FROM Configuration.Collations

I saw in the result table :-

  UNI which is Unicode (Binary)
  ENU which is English (United States)

So how do I force Collate UNI when use the ElevateDB Manager Unicode?

Regards,
  Peter Evans

Peter,

<< I would have expected them to become like :-
   "Subject" VARCHAR(30) COLLATE "UNI", >>

If you don't specifically set the collation during migration (it's on of the
migration parameters), the collation used for the EDB database is determined
by the source tables being migrated from DBISAM.

After you have migrated the database, you can set the default collation for
the EDB Manager by accessing File/Preferences/Dialogs.  However, that won't
change your existing databases.  To do that, you'll have to re-migrate them
or manually alter them all so that they are using the desired collation.

Tim Young
Elevate Software
www.elevatesoft.com