changing language

• Ankam

  Valued Member

  Points: 65

  More actions

  March 4, 2009 at 6:18 am

  #206633

  Hi,

  in my database table having different type of languages like

  id uname

  1 Évian-les-Bains

  2 Évreux

  3 Eysines

  4 Île d?Aix

  5 L?Isle-d?Abeau

  can i get uname values in to english language using select query

  thanks in advance

• Gift Peddie

  SSC Guru

  Points: 73570

  More actions

  March 4, 2009 at 6:41 am

  #953099

  You need the collation below because you can use that for most languages in Europe. You could also run some test using other collations.

  SQL_Latin1_General_Cp850_CI_AS_KI_WI

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

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

  Kind regards,
  Gift Peddie

• thapaswi.coffee

  Newbie

  Points: 1

  More actions

  March 4, 2009 at 10:58 pm

  #953793

  hi lolli

  i have seen ur question iam facing same problem