June 29, 2017 at 3:55 pm
Hi,
I'm installing SAP IPS software and it says "The database client and server must use Unicode character encoding, such as UTF-8."
Can you please let me how to configure this in SQL Server 2016? Is this SQL Server instance level setting or database level?
I know how to do in Oracle but not in SQL Server.
The equivalent for Oracle databases is AL32UTF8
Thanks
July 3, 2017 at 1:44 pm
I'm guessing it's the server default collation, but it is a guess. Not sure which collation would be satisfactory to SAP. I know that might not be all that helpful, but it might at least send you in the right direction.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
July 3, 2017 at 2:41 pm
If you decide to change the default collation for a database to one that's different than model, you may run into collation conflicts in tempdb. This is something to keep in mind as you decide how to configure your instance and databases.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply