Problem Occurring During CSV Import

Dori's profile image Dori posted 1 year ago in General Permalink

When importing a CSV and automatically generating a new table schema, all the table and column names become lowercase. Like "itemId" turns into "itemid". I would like to create them distinguishing between upper and lower case. What should I do?

ansgar's profile image ansgar posted 1 year ago Permalink

There is nothing you can do, the auto-detection always uses lower case column names. But you can manually edit the SQL code, before you click the "Create table" button.

Dori's profile image Dori posted 1 year ago Permalink

Thank you for your response. However, a few months ago, Heidi SQL I used was able to recognize case sensitivity when creating tables. I guess I'll have to try using older versions...

ansgar's profile image ansgar posted 1 year ago Permalink

Indeed, I modified that short before the v12.2 release, so you could use v12.1 to use untouched column names. However, there were also a few other bugs which I solved since then, so don't complain when you run into some crash then.

ansgar's profile image ansgar posted 1 year ago Permalink

This was the relevant modification: commit:9265598d41aacf71343b0e90247e61eeeff0a6a9

Dori's profile image Dori posted 1 year ago Permalink

I understand. Thank you for letting me know.

Please login to leave a reply, or register at first.