Post reply

Can't type Hindi or Kannada into the query window.

  • June 2, 2009 at 1:37 pm

    #99701

    Hey, I have some data ina word document that I want insert into a table.

    The text is Hindi and Kannada.

    When I copy and paste the text into the query window, sql server 2005 dose seem to know how to handle it and shows the following:

    N' ÊÜá¾ ÃÜPܤ¨æãñܤvÜÊÜ®Üá° 130 GÊÜå '

    The text looks perfect in word.

    Any suggestions?

  • June 2, 2009 at 1:44 pm

    #1003608

    You will need Nvarchar and Hindi collation either just the column or even in your DML code and you can save the .sql file as Hindi. In SMS click save as and click the arrow to access all the defined encoding you can choose.

    Kind regards,
    Gift Peddie

  • June 2, 2009 at 1:46 pm

    #1003609

    I already have multiple languages in this column already. what would happen to the text if i change the collation.

    Also, do you have an example of code to chang the collation of the column?

    Thanks!

  • June 2, 2009 at 1:55 pm

    #1003617

    It is not good practice to put more than one language in a column, if this i just names then you can use collation precedence.

    http://msdn.microsoft.com/en-us/library/ms179886.aspx

    Kind regards,
    Gift Peddie

  • June 2, 2009 at 1:58 pm

    #1003621

    Yes I agree! I am finding that out the hard way.

    Thanks for the replies.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply