Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
How to make an Upper Case Field? |
Tue, Jul 10 2012 12:47 PM | Permanent Link |
Rolf Frei eicom GmbH | How can I define an Upper Case Field in EDB2?
DBISAM: .... "ID" CHARACTER(3) NOT NULL CHARCASE UPPER, ... The data should be saved as uppercase in the database. Regards Rolf |
Tue, Jul 10 2012 3:04 PM | Permanent Link |
Raul Team Elevate | I don't think there is an equivalent definition in EDB. EDB is using
collations and while you can specify column as case insensitive for comparisons it won't help converting the data into uppercase. My suggestion would be an insert/update trigger that does the UPPER function on the column. Or if you're adding data thru app then uppercase it before insert (trigger would be more universal though). Raul On 7/10/2012 12:47 PM, Rolf Frei [Team Elevate] wrote: > How can I define an Upper Case Field in EDB2? > > DBISAM: > ... "ID" CHARACTER(3) NOT NULL CHARCASE UPPER, ... > > The data should be saved as uppercase in the database. > > Regards > Rolf |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |