There may be times when you need to convert data being read from the database and being stored to the database. An example of this would be converting a character to a Boolean. In the database, a value may be stored as 'Y', but when it is retrieved, it may be converted to the Boolean object true and vice versa. There are many different types of converters that may be used, for example, VapCharToBoolean, VapCharToString, and so on. You may also create your own converter by subclassing from VapAbstractConverter.
The steps for using a converter are as follows:
This opens the Table Editor.
This opens the Column Editor.
Various vendor database drivers treat single-character data differently. Some will return a Character, some will return a String of length one. To be sure, if an application may run with multiple drivers, type Char(1) fields as Strings, and use the VapCharToString converter. It will guarantee that a String will always be returned.