Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
How to force Collate UNI when use Manager Unicode? |
Sun, Aug 11 2013 8:18 PM | Permanent Link |
Peter Evans | 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 |
Wed, Aug 14 2013 10:59 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Monday, May 6, 2024 at 01:09 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |