Getting an hebrew information from a table

I'm trying to get information about specific field in VB6 but when the field is consists of characters in hebrew, I'm not getting data.

The Code is:

    Dim oSBObob As SAPbobsCOM.SBObob
    Dim oRecStock As SAPbobsCOM.Recordset
    Dim str As String
    
    Set oSBObob = oCompany.GetBusinessObject(BoBridge)
    Set oRecStock = oCompany.GetBusinessObject(BoRecordset)
    
    str = "Select OnHand from OITW where ItemCode = 'בנק'"
    oRecStock.DoQuery (str)

I am getting oRecStock.EOF = true although the record exists.

but when the string is :

str = "Select OnHand from OITW where ItemCode = 'ABC'"

, I am getting results.

What is the reason, Why there is difference between the languages and what can I do in order to solve this?