web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Dynamics GP sql collation
Microsoft Dynamics GP (Archived)

Dynamics GP sql collation

(0) ShareShare
ReportReport
Posted on by Romryan

Hi,

What is the effects of using Latin1_General_CI_AS sql collation in GP databases.I have set sql with this collation on a test environment and it seems like its working fine.All my GP databases were in Latin1_General_CI_AS collation and therefore SQL_Latin1_General_CP1_CI_AS was throwing an error when running utilities so no new gp client installation was possible.I did a new sql server installation with the Latin1_General_CI_AS the same as my company databases backups and now the error is gone and I was able to do client installation.I don't know if this has negative effects on GP as Richard Wheeler once indicate that the two supported collation are 

SQL_Latin1_General_CP1_CI_AS

Latin1_General_BIN.

I tried to change my backups to SQL_Latin1_General_CP1_CI_AS but the procedure ended up in futility.

Kindly advise about the consequences of Latin1_General_CI_AS.

RomRyan

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Hello RomRyan,

    As it is working with no issues then you can live with this, but you need to keep in mind that your environment is not supported from Microsoft support team, they don't have your collation at their test environment.

    You can change your company databases collations, but you might need to drop all collation dependence objects and recreate it using the new collation, I would suggest you connect your partner asking how to get this changed and they can help.

  • Verified answer
    soma Profile Picture
    soma 24,410 on at

    I don't know the exact different between both above mentioned collations.

    But, you should consider below points while installing SQL for GP>

    1. If you installing new sql server for GP on any machine, you can use either one of those collation.

    2. If you installing new sql server for GP with restoring GP databases from anywhere, you should install the SQL server with the same collation of original GP database collations (collation of where you copied the GP database).

    Hope this helps!!!

  • Community Member Profile Picture
    Community Member on at

    The below link discusses in detail

    social.msdn.microsoft.com/.../server-collation-sqllatin1generalcp1cias-versus-latin1generalcias

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans