Non-standard characters in column names

[da...@dealerpeak.com]

Hello.

I have a database that has some column names with spaces and pound signs.  Normally, in MSSQL, I would encapsulate these names in brackets like the following:

[My Funny Table#] INT NULL

Is there a way to allow non-standard characters in column names within your tool?  If not, I'll need to rename my columns, which defeats the purpose of documenting.

Thanks,

David

[Trevor Jobling (QuickDBD)]

Hi David,

Thanks for taking the time to give us some feedback. That's a good suggestion and I don't see any issue implementing it. I've put it on the roadmap (https://trello.com/c/Fr90PZy7/49-delimit-identifiers) and we'll hopefully implement it within a few days. I'll let you know how we get on.

Cheers!

Trevor

[kitti...@gmail.com]

Hi David,

We just deployed a new build of the app which will allow you to use non-standard characters in both table and colum names. We didn't use brackets for this new piece of syntax however but doublequotes.

This means you can now define tables and fields like this when you need to include special characters:

"Non-Standard #1"
--
"Non-Standard #2"
OtherTable
--
OtherField FK -< "Non-Standard #1"."Non-Standard #2"

Hope this helps. :)

Regards,

Tihomir