String types can specify several more attributes."Model definition> type>Types available in WagbyPlease read.
In Wagby, the entered value is corrected by "filter". "Filter" can be automatically corrected by the filter.This function is set automatically.
The filters that can be selected for the string type item are as follows.
Filter that determines input value as "character string".We recommend that you select "String (General)" filter for items that contain values that contain Japanese.The following processing is performed.
That is, this designation includes "character string (minimum)" "half size - full width" "full width single byte" to be described later.
Unify the line feed code to "LF".
If half-width characters are included in the input value, it will be converted to full-width characters corresponding to this one-byte character.
If half-width katakana is included in the input value, this half-width katakana is converted to full-width katakana.
If half-width characters are included in the input value, it will be converted to full-width characters corresponding to this one-byte character.Also convert single-byte spaces to double-byte spaces.
When double-byte characters are included in the input value, it converts to this one-byte character corresponding to this double-byte character.If there is no corresponding one-byte character, it will not be converted.
When double-byte characters are included in the input value, it converts to this one-byte character corresponding to this double-byte character.Also convert double-byte spaces to single-byte spaces.If there is no corresponding one-byte character, it will not be converted.
Allowable character typeWhen you specify, "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)".
Depending on the business specifications, it may be better to change the filter.
"String> Zip CodePlease read.
FilterString (minimum)I will.Then specify the allowable character type as follows.
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.
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.
|HSQLDB (embedded DB)||varchar(255)|