tag:blogger.com,1999:blog-8558386.post4414507653760802984..comments2023-10-21T15:39:23.265+08:00Comments on SAGE ACCPAC ERP Tips & Tricks: "Violation of PRIMARY KEY constraint 'ICUNIT_KEY_0'" when performing a DBload of data into MS-SQLDeLionKinghttp://www.blogger.com/profile/05393489457855215783noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-8558386.post-28755001625460456032009-06-01T00:33:12.725+08:002009-06-01T00:33:12.725+08:00Hello All, I am doing a database load from Pervasi...Hello All, I am doing a database load from Pervasive SQL to Pervasive SQL and I am getting this error. Can you give me any assistance. I am at the client site right now 5/31/2009. <br />khenth6545@aol.comAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8558386.post-2951261027663461182008-09-23T16:35:00.000+08:002008-09-23T16:35:00.000+08:00can you tell us please how can we set the Sort ord...can you tell us please how can we set the Sort order to Case Insensitive?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8558386.post-73187605679300454052008-08-23T00:13:00.000+08:002008-08-23T00:13:00.000+08:00You mentioned that the error could be fixed by set...You mentioned that the error could be fixed by setting the sort order. "Set Sort order to Case Insensitive Set collation name to Latin_general_bin" <BR/><BR/>What else could be causing this issue? <BR/><BR/>My set collation name is set to Latin_general_bin. <BR/><BR/>Does the "Set Sort order to Case Insensitive" mean that it will still let the load occur even if the primary keys are set to the same name (for instance, test1 and TEST1) but are case sensitive? If so, how can I set the Sort order to Case Insensitive?<BR/><BR/>Thanks.Samhttps://www.blogger.com/profile/12986867726280242105noreply@blogger.comtag:blogger.com,1999:blog-8558386.post-88981662056800668732007-06-19T13:42:00.000+08:002007-06-19T13:42:00.000+08:00Thank you for your tips ,it helps me a lot.Thank y...Thank you for your tips ,it helps me a lot.<BR/>Thank youAnonymousnoreply@blogger.com