Table names... case sensitivity
Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6099
Printed Date: 27 December 2024 at 1:36pm
Topic: Table names... case sensitivity
Posted By: atifghaffar
Subject: Table names... case sensitivity
Date 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
|
Replies:
Posted By: atifghaffar
Date 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
|
Posted By: LogSat
Date 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
http://www.logsat.com" rel="nofollow - LogSat Software
http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP
|
|