sql server - db string length errors and NHibernate -
In a SQL Server db I have the name column in the department table, tap nvchar (25), is not unique. I check what happens if I try to name a name with a department and then save it to get "NHibernate.Exceptions.GenericADOException", which makes it clear that "string or Binary data will be deducted ". that's good.
In another table, I have a description column in the Projects table, in which nvchar (50) is not zero, but there is no unique obstacle in it. To ensure that the statement is larger than 50), but no exception has been thrown ...
I like the very clear exception, but I understand what the rules are. Apart from this, the exceptions are all different DBs. What am I missing?
Cheers, Beryllless
Answer
My mistake! I was using a test that used SqlLite instead of SqlServer. This is one of the reasons that I have stopped using SqlLite in the first place (one reason should be that so many smart people love it, but it is useless for the verification of the analyzed mother.
Behavior is controlled by choice:
If an INSERT or Trying to do UPDATE on a single character, Unicode, or Binary column, in which the new value is the maximum size of the column
option is per database option.
Comments
Post a Comment