> I believe that MySQL will let you use any case for any
> entity (caveat
> to come), as long as you're consistent through out a
> single query for
> each entity. So you can differ the case across multiple
> queries, but
> within a single query, every reference has to be cased the
> same. In
> addition, table names, because they directly correspond to
> files on
> the filesystem, are as case sensitive as your file system,
> subject to
> the option described on the page Jochem linked to.
Yea, I noticed that... means I have to revise some of my
cross-platform database code... though it just seems silly... if I'd
been designing something like MySQL I would have just forced all the
file names to lower-case and been done with it and saved everyone the
headache...
> Of course, I could be somewhat off base (and Jochem will
> surely
> correct me), but I stick to my casing rules, so I
> generally don't have
> to care.
My issue is that I have these tools that are designed to allow
cross-platform database access with the same syntax... so in order to
accomplish that, I have to massage the data to create consistent
SQL... Though because Oracle uses all upper-case text in their
case-sensitive meta-data indexes, if you attempt to request columns
for the table "product" it won't return any records. So I used ucase()
to make all the table names upper-case because none of the other
databases care what case the table names are in your SQL if you're not
trying to retreive meta-data. So now I've got to add an "if
(dsn.server is not "mysql") { ...} " around that line... <sigh>... I
hate that.
s. isaac dealey 954.927.5117
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://macromedia.breezecentral.com/p49777853/
http://www.sys-con.com/story/?storyid=44477&DE=1
http://www.sys-con.com/story/?storyid=45569&DE=1
http://www.fusiontap.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193927
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
