Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Table names... case sensitivity
  FAQ FAQ  Forum Search   Register Register  Login Login

Table names... case sensitivity

 Post Reply Post Reply
Author
atifghaffar View Drop Down
Senior Member
Senior Member
Avatar

Joined: 31 May 2006
Location: Switzerland
Status: Offline
Points: 104
Post Options Post Options   Thanks (0) Thanks(0)   Quote atifghaffar Quote  Post ReplyReply Direct Link To This Post Topic: Table names... case sensitivity
    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
Back to Top
atifghaffar View Drop Down
Senior Member
Senior Member
Avatar

Joined: 31 May 2006
Location: Switzerland
Status: Offline
Points: 104
Post Options Post Options   Thanks (0) Thanks(0)   Quote atifghaffar Quote  Post ReplyReply Direct Link To This Post Posted: 08 June 2007 at 7:06am
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
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4104
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 08 June 2007 at 6:10pm
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.
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.227 seconds.