[OpenSIPS-Users] is this a bug? acc module setting empty string for unset fields

[Kingsley Tart]

I could do, but I was hoping to avoid that as it feels like bad
practice and it's inefficient - more of a workaround than a proper fix.

I was really hoping that OpenSIPS would simply not define fields in the
query if the value had not been specified. It seems to do as I wish if
I don't use multi-leg accounting.

Cheers,
Kingsley.

On Mon, 2021-05-10 at 19:15 +0300, Liviu Chircu wrote:
> On 10.05.2021 18:33, Kingsley Tart wrote:
> > I tried setting the fields to NULL in the routing script, and then
> > when
> > that didn't make any difference I tried setting them to 0. That
> > didn't
> > help either.
> 
> Why not just convert all custom (extra, leg) accounting columns to 
> VARCHAR(64) or VARCHAR(128), for example?  While most SQL databases 
> auto-convert integer types to strings, the opposite is _not_ true,
> hence 
> all of the errors you've been running into.
> 
> Best,
>