propelorm/Propel — Issue #305: Allow more characters in identifiers.
Author: hannesg
Created: 2012-02-29 13:36:14+00:00
State: open

Hi

currently there are only wordcharacters and underscores allowed as SQL identifiers ( table / column / index / foreign keys .. ) . However most databases allow far more.
A few examples:

Mysql: unicode except \0 and \10000 and above
http://dev.mysql.com/doc/refman/5.0/en/identifiers.html

Mssql: anything from the current code page
http://msdn.microsoft.com/en-us/library/aa224033%28v=sql.80%29.aspx

Oracle: any character except \0 and "
http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements008.htm

I'm currently hanging around with a legacy system with a foreign-key name like "Foo-Bar" and can't build that with current Propel version. After changing the restriction in the database.xsd everything worked well.

Is there any reason for the current limitation?