arabic language support in SQL Server 2000

• adonis

  SSC Rookie

  Points: 49

  More actions

  July 9, 2001 at 2:51 am

  #100998

  Hello,

  I have SQL SERVER 2000 on WINDOWS 2000 ADVANCED SERVER,

  there is a problem: I use coldfusion language to add data to SQL 2000 Database> .When I open database for retrieve the data the result as : ??????????????????????????

  this is because i use ARABIC LANGUAGE and it is a non UNICODE language .

  -I try to set Arabic as default language in my control panel but the problem not solved>>

  -I try to insert arabic words in NOISE.DAT file but the as before not changed..

  I hope you to advice me and help me to solve the problem

  thank you..

  ahmed

• jwiner

  SSCrazy

  Points: 2241

  More actions

  July 10, 2001 at 6:48 pm

  #417006

  Hope we can help you with your problem...could you give me a more detailed idea of what exactly is going wrong. Might not actually be linked to using Arabic. What do you mean by "When I open database for retrieve the data the result as : ??????????????????????????" Is the data unreadable, etc?

• K. Brian Kelley

  SSC Guru

  Points: 114703

  More actions

  July 10, 2001 at 9:06 pm

  #417016

  What is the collation name of the database? Is it arabic_*?

  K. Brian Kelley

  bkelley@agfirst.com

  K. Brian Kelley
  @kbriankelley