Print Page | Close Window

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: http://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6099
Printed Date: 15 December 2017 at 6:51pm


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



Print Page | Close Window