Joel
Well Known Member
Hello,
We are on 8.12 with SQL server 2008 R2 as the database. We installed Polish language in PY and deployed a full package including Polish language. The task, task views and UBE's get translated however some special characters are being stored as "near English". Our database is Non unicode.
Our collation for business data databases is SQL_SwedishStd_Pref_CP1_CI_AS. Oracle told us it could be a collation issue hence we created a blank database with collation SQL_Latin1_General_CP1_CI_AS and copied the data over. Pointed the data source to this new database which did not help.
If I enter these special characters in any system table for example user profile or in central objects i.e. create a version with Polish special characters it saves successfully. The only difference I see between the system, central objects database V/s business data is unicode.
I have also tried entering data directly from SQL management studio however that too gets saved as English.
Any inputs are appreciated !
- Joel
We are on 8.12 with SQL server 2008 R2 as the database. We installed Polish language in PY and deployed a full package including Polish language. The task, task views and UBE's get translated however some special characters are being stored as "near English". Our database is Non unicode.
Our collation for business data databases is SQL_SwedishStd_Pref_CP1_CI_AS. Oracle told us it could be a collation issue hence we created a blank database with collation SQL_Latin1_General_CP1_CI_AS and copied the data over. Pointed the data source to this new database which did not help.
If I enter these special characters in any system table for example user profile or in central objects i.e. create a version with Polish special characters it saves successfully. The only difference I see between the system, central objects database V/s business data is unicode.
I have also tried entering data directly from SQL management studio however that too gets saved as English.
Any inputs are appreciated !
- Joel