![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
![]() |
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 ![]() | 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 Wednesday, August 14, 2024 at 03:12 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |