Tech Off Post

Single Post Permalink

View Thread: Why does varchar and nvarchar return different resultset in search?
  • User profile image
    PerfectPhase

    gadget wrote:
    
    What DBMS are you using?
    What version? 

    Using Microsoft SQL Server 2005 build 3054 it does.

    Edit: If your collation is set to binary then it doesn't.


    Latin1_General_CI_AS

    SLQ-2005 SP2 3054