Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Location
    Iran
    Posts
    5

    Unanswered: Unicode Query on SQL Server

    I have a table in SqlServer with unicode fields(ntext,nvarchar,..) and the same table in Access with the same data.but a query on both table return defferent result. if i have unicode charachters in my query with sqlserver table it returns eof=true but the same query in access return eof=false
    what is the problem?
    what can i do?

    Query String ="SELECT * FROM NewsTable WHERE Title like '%ق%'"

    my Email : hhamidreza62@yahoo.com

  2. #2
    Join Date
    Dec 2002
    Location
    Antwerp, Belgium
    Posts
    227
    your select statement should be
    Code:
    SELECT * FROM NewsTable WHERE Title like N'%ق%'
    The 'N' is used by SQL server to determine unicode data
    Johan

  3. #3
    Join Date
    Mar 2010
    Posts
    1
    This helped us

    eXtendCode

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •