"A) For string data, we should use AnsiString or String as deduced from the type of the other operand."
Yes, this is paramount. In reality, if a AnsiStringType column reference is used in an expression and not explicitly cast to StringType, it should control the type of any affected operands, unless they are also column references. "B) For string data, the length of the type should be at least the length of the current value. (The driver may further round this up where useful)." Yes, that's sensible. Unless the length is explicitly set, it should be deduced from the value. It makes sense that the driver can fiddle with the parameters if necessary, but should it know whether a parameter's length was explicitly set from the beginning? "select e.col + @param from ... would also not work if the value of the parameter is longer than the mapped size of col." True, but that was what I was fixing in the StartWith code, which performs a concatenation with "%". /G -- --- You received this message because you are subscribed to the Google Groups "nhibernate-development" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
