What is Arabic Collation for Dynamics GP 2013?

(0) Share

Report

Posted on by Community Member

When implemented GP2013 SP2 Eng V12.00.1482 with collation {SQL_Latin1_General_CP1_CI_AS} as Database Requirements for GP2013, unfortunately it doesn't support Arabic language.

I know the older version required collation {Arabic_CI_AS} for Arabic, but I think it'll not work with 2013.

FYI

OS : Win Server 2012 -Region -unicode Arabic

SQL: SQL SVR 2008 R2

Is there a person have ideas?

Thanks

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Richard Whaley 25,195 on at

Like (0)

Report

The collation sequence is specified in the installation of MS-SQL, not GP (although many install both at the same time). Is there an Arabic_CI_AS collation in SQL 2008? You should be able to use it.

Was this reply helpful? Yes No
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

Yes there is Arabic_CI_AS in SQL 2008. During SQL Server 2008 installation, you will be asked to choose the collation. In case the SQL Server is already installed, you could run the following select statement to check the collation properties;

SELECT CONVERT (VARCHAR, SERVERPROPERTY('collation'))

EXECUTE sp_helpsort;

I have SQL Server 2008 R2 with GP 2013 installed on my test machine, here is the SQL Collation as retrieved from the first select statement above;

Hope this helps,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

@All

Thanks your reply.

when tested it on a server it is well done, but the errors appears when connect a terminal to this server

when connect win 8 Pro to this server found following error with the client machines...

1-      In dynamics gp utilities .. it is frozen then not responding

2-      When checking ODBC found



3-      So I try to change to sa & sa password, but found

I’m really appreciate you responding

Thanks

Was this reply helpful? Yes No
Jonathan Fear on at

Like (0)

Report

GP is not supported with that collation. You can only use 50 or 52.

Was this reply helpful? Yes No