"The client code page 65001 does not have a corresponding SQL Server Collation. InMemory Rowset creation failed."

"The client code page 65001 does not have a corresponding SQL Server Collation. InMemory Rowset creation failed."

A customer has set a Windows setting that was marked as beta, but is probably now required by several applications: 

Control Panel > Clock and Region > Region > Administrative tab > Change system locale button > Beta:Use Unicode UTF-8 for worldwide language support.

One of the most significant effects is that the code page 65001 (UTF-8) becomes standard, which has a number of other consequences (e.g. the format of code files is also interpreted as UTF-8 if it is active on a development computer, etc.).

The error occurs as soon as I use a TableType (even those without a string type) like the following:
  1. CREATE TYPE [dbo].[IdTableType] AS TABLE
  2. (
  3.     [Id] INT NOT NULL PRIMARY KEY
  4. )

Is there any way to change the code page used in the SDAC components? Or does anyone have another solution (disabling this Windows setting is unfortunately not one).