Table names... case sensitivity |
Post Reply |
Author | |
atifghaffar
Senior Member Joined: 31 May 2006 Location: Switzerland Status: Offline Points: 104 |
Post Options
Thanks(0)
Posted: 08 June 2007 at 6:24am |
Hello Roberto,
I attempt to build a database with the enterprize sql script today. Seems like there are mix case problems that might work fine on windows but not a unix machine. I have problems for example with tblWL_EmailsTO. It is referenced as tblWL_EmailsTO and tblWL_EmailsTo. which one is correct? Same problem with tblWL_AutoWhitelistForceDelivery and tblWL_AutoWhiteListForceDelivery How does SF handles this, should be case of all tables be lowered on the database? thanks and best regards. Atif |
|
best regards
Atif |
|
atifghaffar
Senior Member Joined: 31 May 2006 Location: Switzerland Status: Offline Points: 104 |
Post Options
Thanks(0)
|
hello again,
I see that sf is lowecasing all fields and table names. so a simple cat filename | tr A-Z a-z did the trick |
|
best regards
Atif |
|
LogSat
Admin Group Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
|
Atif,
You're correct. The script containes the table names in mixed case for readibility. SpamFilter will convert that in lower case before executing it. However running the SQL script "manually" would cause issues on a Unix server, unless it's converted to lower case as you did. |
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.227 seconds.