none
problem in c# & sql RRS feed

  • Question

  • hello.i  have 3 table . i inter persian in tabeles. but when i search with query search ,i don't see rows in tables and dont give  row's tables.

    how i can write query for search persian's input?

    i write code right  for search . but it cant give me right result.

    thank you .

    • Moved by Stanly Fan Tuesday, March 13, 2018 1:40 AM
    Sunday, March 4, 2018 6:45 AM

All replies

  • About the only thing to try is preceding the string with N (national character) 

    "NATIONAL" in this case means characters specific to different nationalities.

    So we would use "SELECT CompanyName FROM Company WHERE ContactType = N'Marketing Assistant'"


    Please remember to mark the replies as answers if they help and unmark them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.
    VB Forums - moderator
    profile for Karen Payne on Stack Exchange, a network of free, community-driven Q&A sites

    • Proposed as answer by Stanly Fan Tuesday, March 6, 2018 1:30 AM
    • Unproposed as answer by Stanly Fan Monday, March 12, 2018 9:17 AM
    • Proposed as answer by Stanly Fan Monday, March 12, 2018 9:17 AM
    Sunday, March 4, 2018 10:51 AM