Yes, that's what I'm hearing. The required change to code is a pain, but the big problem that I see is that to do a selection query requires reading the entire table. An index on the character fields does us no good.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 11:01 AM To: Dave Guyer Cc: SAP List; Scott Carlson; Nathan Morrow Subject: Re: Case insensitive queries in SAP? Yeah, we hit this too. :-( There is no flag - you have to change your queries to convert both parts of your comparisons to uppercase (or lower) - so when you are creating the SQL, change the parameter you are comparing against to upper case, and then use the UPPER function in SAP to create the field to upper to do the compare. HTH, David Dave Guyer <[EMAIL PROTECTED]>@listserv.sap.com on 19/06/2003 01:11:49 PM Sent by: [EMAIL PROTECTED] To: SAP List <[EMAIL PROTECTED]> cc: Scott Carlson <[EMAIL PROTECTED]>, Nathan Morrow <[EMAIL PROTECTED]> Subject: Case insensitive queries in SAP? I just received a call from our JAVA development Team Lead indicating that initial experiments with SAP DB shows that queries of character data are case sensitive. This testing was done both with SQL Studio and with JAVA code and the JDBC connection. They have coded for databases where queries are not case sensitive. Is there a flag that can be set to change this or some other way to change it besides modifying the code for every query? If not, what change would be required in the code? Part of the problem is that we will be working with data from Progress databases. Progress by default is not case sensitive, so we can't depend on the case of the data. _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
