JDBC.jl icon indicating copy to clipboard operation
JDBC.jl copied to clipboard

problems with `getNString`

Open ExpandingMan opened this issue 8 years ago • 0 comments

Some drivers (in my case presto) appear to not support getNString. In such cases, getString seems to work just fine. The problem this presents us with is how to choose which function to use (this matters for the vast majority of cases which are automated such as dumping into DataFrames). Note that right now these functions are looked up in a Dict depending on their JDBC type code.

I actually don't seem to have anywhere where I can test getString on drivers which support getNString (I'm not entirely sure what those are anyway).

Any thoughts on this? Can anyone check if getString works for them in place of getNString? It would be really nice if we can just get rid of getNString. Error catching would be waaaay too slow here.

The only other alternative I could see would be to create a function that changes the Dict appropriately on user command. This is inelegant and entrenches an existing efficiency problem, but should work.

ExpandingMan avatar Jan 10 '18 20:01 ExpandingMan