I will explain the use point of the character string type.

String types can specify several more attributes."Model> Type> Wagby available type" Please read.

The entered value is corrected by "filter". For details, please read "Input filter specifications".

Figure 1 Input filter

Input filter and allowable character type

When an allowable character type is specified, the "string (minimum)" filter is automatically applied.

For example, if you specify a full-width numeric character for an allowable character type, if the input filter remains "character string (general)", the filter converts "full-width numeric" to "half-width numeric" so that input can not be performed.
Avoid this problem by setting the filter to "string (minimum)".

Set the input filter manually

Depending on the business specifications, it may be better to change the filter.

Example Zip code, address item

Please read "String> Zip Code".

Example I want to input half-width katakana characters only

Make the filter a string (minimum).Then specify the allowable character type as follows.

  • Allowable character type setting: Katakana - half-width character
  • Allowable character type setting: space

Within Wagby there is no limitation on the size of the string type. But when saved in the database, it needs to fit within the column of the database.

The standard sizes of string types stored in the database are as follows.

Database Definition
Oracle varchar2(255 char)
SQL Server nvarchar(255)
DB2 varchar(255)
MySQL varchar(255)
The number specified by varchar type depends on MySQL version.Before 4.1, it is in "byte" unit, but after that it is in "character" unit.Please check the MySQL manual for details.
PostgreSQL varchar(255)
HSQLDB (embedded DB) varchar(255)