VB6 Access unicode problem

Posted on 2005-04-15
Last Modified: 2006-11-18
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
Question by:mumbing167
    1 Comment

    Accepted Solution

    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

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    only14 challenge 19 57
    scoresClump  challenge 31 86
    SPLUNK REST  API call to Splunk to create and index? 2 43
    allStar challenge 1 27
    RIA (Rich Internet Application) tools are interactive internet applications which have many of the characteristics of desktop applications. The RIA tools typically deliver output either by the way of a site-specific browser or via browser plug-in. T…
    If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
    An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
    Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now