1,105,644 Community Members

case sensitive comparisions

Member Avatar
baabjitvk
Newbie Poster
13 posts since Jan 2013
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

hi
when i'm giving some string to search in the data base, ms access, that search is going to be ignoring case. i want case sensitivity. how..?
ex: if i would like to search for the word "Done", if there is no that word, and "DONE" is available in the database, then it is treating both as same. how to avoid this.

Member Avatar
tinstaafl
Postaholic
2,014 posts since Jun 2010
Reputation Points: 559 [?]
Q&As Helped to Solve: 403 [?]
Skill Endorsements: 36 [?]
 
0
 

Show the code you're using to do the search.

Member Avatar
baabjitvk
Newbie Poster
13 posts since Jan 2013
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

For q As Integer = 0 To spl.Length - 1

            s = "select san from dictionary where tinglish ='" & spl(q) & "'"


        cmd = New OdbcCommand(san, cn)
        dr = cmd.ExecuteReader()
        If (dr.Read()) Then
            singl(q) = dr.GetString(0)
        End If
        nsinglishstring = Join(singl)
    Next q
Member Avatar
tinstaafl
Postaholic
2,014 posts since Jun 2010
Reputation Points: 559 [?]
Q&As Helped to Solve: 403 [?]
Skill Endorsements: 36 [?]
 
0
 

Here's a thread that discusses this topic and contains a solution.

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article