This does not break functionality

pena's profile image pena posted 1 week ago in General Permalink

This does not break functionality, but for legacy environments it becomes confusing, especially for teams working with older COBOL/ERP systems where uppercase naming conventions are heavily used.

Would it be possible to add an option such as:

“Preserve original identifier case” “Display object names using metadata case”

This would help environments that rely on traditional uppercase naming conventions.

Thank you for the excellent software and support.

ansgar's profile image ansgar posted 1 week ago Permalink

Sorry, what is the situation you describe here? Is it the SQL editor and you mean column names taken from the completion proposal? These should be preserved as they're defined in the table (see the "Column 1" column name):

grafik.png

pena's profile image pena posted 1 week ago Permalink

Heidi forces the table name to be in lowercase. I've attached a screenshot.

1 attachment(s):
  • tabela
ansgar's profile image ansgar posted 7 days ago Permalink

I have configured MariaDB on Windows with lower-case-table-names=2 in my.ini, so I can create tables which keep the written case. But this is a server configuration. You might have done the same, or you run a Linux server, however.

Now HeidiSQL does not force the name to lowercase when using the completion proposal. You may write the lowercase name by hand, but that is then up to you. Here's a recording of the completion proposal.

1 attachment(s):
  • completion-tablename-case
FeverBeaver's profile image FeverBeaver posted 5 days ago Permalink

Hi,

Defaults for lower-case-table-names are 0 and it does not seem to force any case on a Linux server either, running MariaDB 10.11.14 on Linux here. (the sample query was using the completion editor)

Regards

2 attachment(s):
  • file
  • variables

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