VB6 Access unicode problem

If I have data which store in SQL server which is encode in unicode, and I want to access those data like
select * from customer where company like 'str%'
but it doesn't find anything, I am sure there are some data match in database
Who is Participating?
lungwaConnect With a Mentor Commented:
you should use the character N
select * from customer where comapny like N'str%'
which tell the sql server you are looking for unicode string
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.