Databases and Special Characters

Home » Databases and Special Characters

The names of any database related entities (like databases, tables, columns, view, stored procedures) should be plain text and not contain any spaces or special characters (for example, hyphens and periods). Using these characters will create endless difficulties for client applications (like ColdFusion). For example, a column named “first-name” would likely be treated as two columns separated by a minus – “first” minus “name”. Similarly, “first name” would throw a syntax error because it would be assumed that you were using two columns (“first” and “name”) and had omitted the comma separating them. As you can see, this kind of naming causes all sorts of grief. Most decent databases do not even allow this type of naming, but some databases do. If you are using a database that allows this practice, avoid it anyway. (Applies to: ColdFusion All)

Leave a Reply