Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

lotus JDBC driver : have you noticed this ? problem with caps

Status
Not open for further replies.

tyris

Programmer
Nov 2, 2000
311
FR
hi all,
i have a problem with queries using lotus.jdbc.domino
it seems that the query must absolutly repect caps and non caps.

for example : (where TEST is a view)

if i make a search for a string like this "Valbone"
and if my query is like this : SELECT myString form TEST WHERE (myString LIKE 'v%') it returns no results.
i must absolutly use : SELECT myString form TEST WHERE (myString LIKE 'V%') (with V in stead of v)

in the same way, if my query is SELECT myString form TEST WHERE (myString LIKE 'A%') it will return no results until my query is SELECT myString form TEST WHERE (myString LIKE 'a%')

what's the problem ? is it because of the Lotus Domino Driver for JDBC? (as i know that this driver already have problems with non english car...)
any idea ?
Best regards X-),
Elise
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top