Skip to content
+1-888-319-3663

COMMUNITY FORUM

SQL Collation

Matt Connor asked 6 years ago
On the same SQL query as my previous post: USE DYNAMICS insert into Activity (USERID, CMPNYNAM, LOGINDAT, LOGINTIM, SQLSESID, Language_ID, IsWebClient) values (‘jp1′,’Test Company’, ’14/05/2015 00:00:00′, ’01/01/1900 22:24:36′, 9708, 1, 0) I note that this would fail on a case sensitive or binary SQL collation, Activity should of course be ACTIVITY Thanks Matt’
Answers
Patrick Roth Staff answered 6 years ago
Matt,
I took at look and my insert looks like yours.
I suspect that this would cause GP to crash due to the SQL insert error that would occur the same as the SQL Date Format issue you had brought up previously.
I wrote this up as bug 11509.
patrickMatt

If you would like to submit an answer or comment, please sign in to the eOne portal.