Is there a way to check connection properties of an active SQL Server connection?
That property is a setting for the client-side of the connection.  Not the server-side, so you won't be able to directly observe this setting from SQL Server.

You can observe the effect of that setting using SQL Server Profiler or Extended Events, looking for the Batch and RPC events.  They will show you the parameter data types sent by the client.