[sr-dev] sql column type check

[Henning Westerholt]

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