none
the query doesn't return result RRS feed

  • Question

  • Hi, every body

    I made backup from sql server 2008 to sql server 2005 but there is problem :
    when i query Arabic data but it return non result although there are Arabic data in Table , how i can solve it?
    Wednesday, March 10, 2010 10:07 AM

Answers

  • I solve the probelm by change the server collaction of database to Arabic_CI_AS
    many thanks for everybody
    Thursday, March 11, 2010 7:00 PM

All replies

  • Hello Fadwa Mohammed,

    If you open the table (SELECT * FROM TableName), can you see any data at all?
    Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich täglich http://olafhelper.over-blog.de
    Wednesday, March 10, 2010 5:38 PM
  • Fadwa,

    How are you querying the data from the new database that has Arabic data? How can you tell there is data?
    Abdallah El-Chal, PMP, ITIL, MCTS
    Wednesday, March 10, 2010 5:50 PM
  • I backup the database from Sql server 2008 the server collation is SQL_Latina1_CI ...etc, to sql server 2005 the server collation is Arabic_CI_AS , is this reason my problem?
    Thursday, March 11, 2010 5:41 AM
  • Arent yout able to see resultset of any tables or specific tables ?

    Thursday, March 11, 2010 7:22 AM
  • I solve the probelm by change the server collaction of database to Arabic_CI_AS
    many thanks for everybody
    Thursday, March 11, 2010 7:00 PM