Not sure this is a JDBC issue. This could be FileMaker. As far as I know JDBC is not by default case sensitive. But in FileMaker 10 and 11 if the field is set to type unicode instead of english the searchers will be case sensitive. So check that 1st. Its on the storage tab in the field definition. a quick google search leads me to believe that the JDBC is by default case insensitive is ODBC. -- Dan Stein MSN CPNP Digital Software Solutions [email protected] www.dss-db.com
On Mar 31, 2011, at 4:52 PM, Shannon Henderson wrote: > Have you tried using the upper or lower() functions in sql? Something > like this: > > select * from some_table > where lower(the_field) = '<@lower str="<@arg blah>">' > > or this: > > select * from some_table > where upper(the_field) = '<@upper str="<@arg blah>">' > > > ------------------------ > Shannon Henderson > Web Support Services > Reed College > Portland, Oregon > 503/517-7745 > [email protected] > > On 3/30/2011 10:14 PM, Wayne Irvine wrote: >> I'm finding it hard work making allowances for JDBCs fussiness. All my code >> accepts search criteria such as: >> >> nsw >> >> And finds records that contain: >> >> nsw, NSW, and even nSw. >> >> Not with JDBC. IT MUST BE EXACT! >> >> At present I am making a new field for every field that is searched and >> making it equal to a lowercase version. I append 'LC' onto the field name. >> >> Then when I search it I user the<@LOWER> tag on the arg. Hence it will work >> as it always used to. >> >> This is fine on a search that looks at four fields but a tad arduous (and >> damn annoying) on one that searches 100 fields. >> >> I'm pretty sure I'm not the first to face this frustration. What are the >> methods used to cope with this and why is JDBC more primitive that FileMaker? >> >> Wayne Irvine >> >> ---------------------------------------- >> >> To unsubscribe from this list, please send an email to [email protected] >> with "unsubscribe witango-talk" in the body. >> >> > > > ---------------------------------------- > > To unsubscribe from this list, please send an email to [email protected] > with "unsubscribe witango-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body.
