search

Arp-G / csv2sql

A blazing fast fully-automated CSV to database importer
MIT License
54 stars 4 forks source link

Dynamically infer varchar column name #27

Open Arp-G opened 2 years ago

Arp-G commented 2 years ago

We must dynamically infer the column's varchar size by finding the max data size in that column. So the varchar_limit the user specifies must only be used to decide when to switch from varchar to text.

Helps in fixing: https://github.com/Arp-G/csv2sql/issues/25

Also contains some minor cleanup and fixes.

Arp-G commented 2 years ago

for empty columns set varchar(1)