On Wednesday 21 September 2011, Henning Westerholt wrote:
[..]
Hello,
So if a server-wide parameter "skip db value type checks" exists, the kamailio user will be able to choose the preferred model....
Such a parameter would probably work, but i wonder if this is really
s/probably/maybe
necessary. From a kamailio POV we support our table structure, and if you don't want to use it, you need to be compatible to it. Have you thought about fixing your view that it returns the value that are expected? ;-)
Or a int parameter for different levels of security, for different type of data (auth_db data changes frequently/is modified by end-users (lower security level required to bypass checks), lcr data is changed by employees only (higher security level sufficient to bypass checks)).
Have you already tried to debug this issue further? If you enable debugging, you get plenty of output from the database modules which shows you the type conversion done, values from the client library etc..
Regards,
Henning