Tag Info

Hot answers tagged


in sql you can write something like this : SELECT * FROM x where pipedn >= 5 AND pipedn <= 10 or SELECT * FROM table x WHERE pipedn BETWEEN 5 AND 10 these examples show howto use WHERE if all your tables are same you can do: SELECT col1, col2 from x UNION ALL SELECT col1 , col2 from table y this one select two table x and y and creates ...


SQLite does not care about types and VARCHAR and NVARCHAR mean just the same for it http://stackoverflow.com/questions/3930501/difference-between-varchar-nvarchar-in-sqlite. The real problem is in the GDAL MapInfo driver that does not handle character encodings. There are some workarounds: Convert MapInfo data into MID/MIF format with ogr2ogr and convert ...

Only top voted, non community-wiki answers of a minimum length are eligible