How to Store (and Retrieve) Non-English Characters (e.g. Hindi, Czech, Arabic etc.) in SQL Server

Aalam Rangi

Important:

I have moved this blog to a new domain. Please continue reading this article at the new location. Apologies for any inconvenience.
Click here to continue reading…

14 thoughts on “How to Store (and Retrieve) Non-English Characters (e.g. Hindi, Czech, Arabic etc.) in SQL Server”

  2. megha Oct 31, 2012 / 8:19 AM

    hi,

    i tried as your example

    but still its showing in the data field like some square boxes

    plz give some suggestion

    Reply
  3. geetha Jan 8, 2013 / 6:49 AM

    thanks very useful

    Reply
  4. Kie Veasna Feb 6, 2013 / 12:30 PM

    I spent a few hours. Finally, I found your topic it helpful. I’m so glad.

    Reply
  7. abhi Feb 16, 2014 / 3:58 AM

    thenks but dynamic string data not supported

    Reply
  8. parv Feb 26, 2014 / 2:18 AM

    may i know what version of mysql support unicode..like hindi .
    Because when i am inserting same code it is showing me ‘?????’
    please reply parvkashyap@gmail.com

    Reply
  10. imaphpdeveloper Dec 20, 2014 / 3:50 AM

    How to fetch the data stored with N, because yes its fine while inserting but while fetching its shows some truncated values

    Reply
    • Aalam Rangi Dec 20, 2014 / 12:20 PM

      Could you try increasing the width of the variables or columns?

      Reply
  11. Rajesh Kumar Maurya Apr 16, 2015 / 3:17 PM

    nice, article….

    Reply
  12. Vijay Soni Nov 30, 2015 / 12:22 AM

    Many thanks!!!

    Reply
    • Aalam Rangi Nov 30, 2015 / 12:29 AM

      You are welcome, Vijay! Are there any other topics that you’d like to read about? I always welcome new blog post ideas!

      Reply

Have a question or a suggestion?