[Gretl-devel] Re: ODBC connector
On Fri, 28 Feb 2020, Riccardo (Jack) Lucchetti wrote:
While we're on the subject: I need to pull a string-valued series
from an ODBC source, which is not possible at present (if I'm not
mistaken). Shall we leave this for after release?
There's now an initial go at this in git. When the "data" command
identifies a column in a db table that is marked as of one of the
string types (SQL_CHAR, SQL_VARCHAR, SQL_WCHAR, SQL_WVARCHAR) we
import it as a string-valued series.
Please test! I can envisage encoding issues that we might have to
deal with. I can also envisage surprising results if a db table has
been set up wrongly -- numeric data entered, but as strings so far
as SQL is concerned. Up till now we'd automatically convert strings
that represent numeric values to numeric values, but as things stand
in git we'll take the values to be strings if that's what SQL says
they are.
Allin