Results 1 to 7 of 7
  1. #1
    Join Date
    Aug 2010
    Posts
    25

    Unanswered: Textfield mismatching order

    Textfield mismatching order in same table in dev & test servers


    we have 2 servers A(Dev) & B(Test),

    suppose in table 'XYZ' i'm getting field in text data as 0,23 ,If i restore the same table from dev to test it is displaying in reverse order 23,0.

    Any help is appreciated

  2. #2
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    Quote Originally Posted by capvenu View Post
    Textfield mismatching order in same table in dev & test servers


    we have 2 servers A(Dev) & B(Test),

    suppose in table 'XYZ' i'm getting field in text data as 0,23 ,If i restore the same table from dev to test it is displaying in reverse order 23,0.

    Any help is appreciated
    Maybe one table, column is text or varchar and other table, column is decimal? Why is there a comma in the text data?

  3. #3
    Join Date
    Aug 2010
    Posts
    25
    both are same data type fields,previously no issues,strtd giving trouble since yesterday

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    How are you doing the backup/restore?

  5. #5
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    Quote Originally Posted by capvenu View Post
    both are same data type fields,previously no issues,strtd giving trouble since yesterday
    So what changed since yesterday?

  6. #6
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    Quote Originally Posted by MCrowley View Post
    How are you doing the backup/restore?
    I was going to ask this same question, but I wonder if he doesn't mean copy?

  7. #7
    Join Date
    Aug 2010
    Posts
    25
    restoring frm ltspeed bkups

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •