locked
unicode (bulgarian) data into latin table RRS feed

  • Question

  • hi, i've bulgarian text into a latin encoded table. i see the datum in this way: "ÄíÚ¿ ñá¡¡¿,äá¡¡¿ ºá óÓÛº¬á,ŽáÚá¡¿´,Å«¬Ò»¬á". i want to create a new table which contains the same data but encoded in the right way (and human-readable). how can i do?

     

    thanks


    logan
    Monday, January 23, 2012 9:58 AM

Answers

  • Hi logan,

    To store Unicode string on SQL Server, you may need to define the NVARCHAR or NCHAR data type for a column, and with a prefix N preceded while you insert into the value.

    If you are attempted to convert the unreadable characters in your latin encoded table to bulgarian unicode which is readable, it might be not available by SQL Server. You may look for other programmatic methods for this type of converting. Please have a look at this thread: problem on convert Unicode (NVarchar) to Ascii (Varchar).


    Stephanie Lv

    TechNet Community Support

    • Marked as answer by Stephanie Lv Monday, January 30, 2012 8:02 AM
    Wednesday, January 25, 2012 3:39 AM

All replies

  • logan

    create a table with column defined as NAVRCHAR(n) and insert the data or have a column with VARCHAR but with Bulgarian COLLATION



    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Monday, January 23, 2012 11:44 AM
  • logan

    create a table with column defined as NAVRCHAR(n) and insert the data or have a column with VARCHAR but with Bulgarian COLLATION



    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

    thanks!

    the only doubt i have is: will i see normale (human readable) data into this new table if i make a "insert from select" onto other latin-encoded table? i have to migrate the latin into this new one...

     

    thanks


    logan
    Monday, January 23, 2012 1:05 PM
  • Hi logan,

    To store Unicode string on SQL Server, you may need to define the NVARCHAR or NCHAR data type for a column, and with a prefix N preceded while you insert into the value.

    If you are attempted to convert the unreadable characters in your latin encoded table to bulgarian unicode which is readable, it might be not available by SQL Server. You may look for other programmatic methods for this type of converting. Please have a look at this thread: problem on convert Unicode (NVarchar) to Ascii (Varchar).


    Stephanie Lv

    TechNet Community Support

    • Marked as answer by Stephanie Lv Monday, January 30, 2012 8:02 AM
    Wednesday, January 25, 2012 3:39 AM
  • check this thread just to have an idea of how to convert non-unicode table to unicode table

    http://sqlserverpedia.com/blog/sql-server-2005/how-do-i-convert-non-unicode-tables-to-unicode-tables/

     

    Wednesday, January 25, 2012 8:22 AM