sqliteman icon indicating copy to clipboard operation
sqliteman copied to clipboard

Retain Table Name Casing

Open TheBuzzSaw opened this issue 10 years ago • 10 comments

The table list converts each name to all lowercase. This makes the table list harder to read if the convention used was camel casing. Is there a reason they are all forced to lowercase?

TheBuzzSaw avatar Jun 23 '14 16:06 TheBuzzSaw

I noticed this recently, luckily it had no negative effect as my table names were one word but I had to avoid using the editor for another database that used camel-case in fear it would mess up the names when I did an alter table command (I tested this, it did!)

Would be great if it could be fixed!

Southclaws avatar Jun 24 '14 15:06 Southclaws

I'm running into this also. I have some descriptive table names and it always displays them lowercase and they are much harder to read. I did notice that if I do a DESCRIBE on the table, it will show it as being mixed case. Hate to hear that an alter can cause the casing to change. Is this something that might get fixed?

Austentacious avatar Jul 23 '15 18:07 Austentacious

Considering I opened this a year ago, maybe I just need to fork it and attempt the fix myself.

TheBuzzSaw avatar Jul 23 '15 18:07 TheBuzzSaw

This (as well as many other bugs) is fixed in rparkins999/sqliteman.

rparkins999 avatar Oct 11 '15 19:10 rparkins999

Hi rparkins999, Did you get a volunteer already to build it for Windows? I have a Windows system with Visual Studio 2008. I wish I knew how to build it, but I have no real clue. Use CMake or so???

sbhoek avatar Aug 28 '18 12:08 sbhoek

I dunno that I'll ever address this myself. I've long since moved onto other tools.

TheBuzzSaw avatar Aug 28 '18 16:08 TheBuzzSaw

No, I didn't get a volunteer to build on Windows. If you can get a command window, cmake and the make should build it. If you try it and it doesn't work, post the output from both the cmake and the make and I'll try and see if I can fix it. If it does work, please do a pull request with the .exe file.

rparkins999 avatar Aug 28 '18 16:08 rparkins999

If you clone the rparkins999/sqliteman repository, navigate to Sqliteman/sqliteman/doc/en/, and open index.html with your favourite browser. you will get into sqliteman's help system. Appendix A tells you how to build and install it and what libraries are required. I think you need to download sqlite.c from the sqlite website and make a small edit to it: this is described somewhere in the release notes in githib.

rparkins999 avatar Aug 28 '18 17:08 rparkins999

... actually it's sqlite3.c, and the edited version is already included in the repository. You only have to edit if you replace sqlite3.c with a more recent version from the sqlite website. Instructions for doing this are in the file README - updating version.

rparkins999 avatar Aug 28 '18 17:08 rparkins999

Thank you for the instructions. I don't have time to work on this without interruption, but I intend to do it in between other tasks. I've started by installing CMake on Windows and on my Xubuntu instance, which I run under VirtualBox. I'll keep you updated ...  

Gesendet: Dienstag, 28. August 2018 um 19:21 Uhr Von: rparkins999 [email protected] An: pvanek/sqliteman [email protected] Cc: Steven [email protected], Comment [email protected] Betreff: Re: [pvanek/sqliteman] Retain Table Name Casing (#10)

... actually it's sqlite3.c, and the edited version is already included in the repository. You only have to edit if you replace sqlite3.c with a more recent version from the sqlite website. Instructions for doing this are in the file README - updating version.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.

sbhoek avatar Aug 29 '18 08:08 sbhoek