S.Isaac Dealey wrote:
>
> 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.
The SQL standard says:
- unquoted identifiers should be converted to uppercase and then
matched to objects in the database
- quoted identifiers should be literally matched to objects in
the database
- identifier quoting is done by double quotes
So technically Oracle does the right thing.
Jochem
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193942
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=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
