>Generally, to avoid these sorts of differences, you write SQL
>that will work the same way in either case. For example, you
>can force case-insensitive comparisons using the LIKE operator.
LIKE is case sensitive in Oracle. If you hadn't done so already you
would have to go through (all) your SQL and force case insensitivity by
coding in the form
WHERE UPPER(dbfield) LIKE UPPER('%#searchvalue#%')
/t
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:202409
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
