The Linux Page

Spaces in database column names

Most of the database systems I've worked with do not support having column names with a space.

Oracle and PostgreSQL accept double quotes for that purpose (i.e. "First Name").

MS-Access and MySQL accept back quotes (i.e. `First Name`)

Visual Basic accepts square brackets (i.e. [First Name])

Obviously, this is just plain craziness! One should just never use spaces in such a place since it completely breaks the object oriented capabilities of pretty much any sensical language.