I have a VB6 ADO recordest that contains unicode text and need to filter it using .filter method with unicode text. I tried to use N' function but it does not work when I use it in .Filter text
Rs.filter = "Name = 'Apple'" 'OK
Rs.Filter = "Name = N'英語'" 'Not working for filter text
How I should wrap the text or I need to use another function?