Different "encoding" after restoring database

martinhocosta88martinhocosta88 Member Posts: 27
edited 2016-08-22 in NAV Three Tier
Hello,

Lately I have been moving some databases from a local environment to Azure. All the data that contains the symbol "~" got a diferent encoding.
Even though the default collation from both instances are slightly diferent, the database collations (that i think it overwrites the instance default collation) is the same in both sides.
Any clue on what am I missing?

Best Answer

Answers

  • TallyHoTallyHo Member Posts: 415
    edited 2016-08-22
    Did you use the SQL Database Migration Wizard ?
    https://sqlazuremw.codeplex.com/
  • martinhocosta88martinhocosta88 Member Posts: 27
    edited 2016-08-22
    I didn't because I'm not using SQL Azure. In my case I'm using a virtual machine with SQL Server.
  • TallyHoTallyHo Member Posts: 415
    It could be a code page issue.
  • wakestarwakestar Member Posts: 207
    TallyHo wrote: »
    It could be a code page issue.

    that's what I meant with regional settings
  • TallyHoTallyHo Member Posts: 415
    Sorry didn't see your post. You're right, it is basically a search in the same direction.
  • martinhocosta88martinhocosta88 Member Posts: 27
    Thank you both for the help. Regional Settings as you sugested! :)
  • martinhocosta88martinhocosta88 Member Posts: 27
    Well it actually solved on Development Environment, but not on rtc and I've restarted the service..
Sign In or Register to comment.