In PostgreSQL Validator does not work when input a string of numbers only, such as 001206
In PostgreSQL Validator does not work when input a string of numbers only, such as 001206
First of all, thank you very much Allan for answering my question!
https://datatables.net/forums/discussion/74619/postgressql-can-not-input-decimal-type#Comment_214551
This solved the problem of displaying decimals, but something new was bothering me. I set a field to display the number-only code, which starts with a 0
, such as 001206
. In the Database, here's the setting.
If this field is set to int
, the preceding 0
will not be displayed, like 1206
instead of 001206
it is I can accomplish inputting that number-only string when the code in my Controller and Model looks like this.
.Field(new Field("office")
.DbType(System.Data.DbType.AnsiString)
)
public string office { get; set; }
And the results are shown below.
But when I added Validator like this ↓, I encountered an error: 42883: operator does not exist: text = integer
,
And this error occurs only when all the input is numeric characters.
.Field(new Field("office")
.Validator(Validation.Unique(new ValidationOpts
{
Message = "Please enter a unique code"
}))
.DbType(System.Data.DbType.AnsiString)
)
How to set parameters to make the Validator function work properly?
Thanks for your help!