I have a simple table with an NVARCHAR column and some random Korean and Chinese characters. I can successfully query the database and output this column to the my browser in addition to passing an UTF-8 NVARCHAR variable out from the Stored Procedure regardless of whether the option that is suppose to enable it is checked.
-- Enable High ASCII characters and Unicode for data sources configured for non-Latin characters
I verified multiple times that it's unchecked yet the output is as expected in UTF-8 characters (not gibberish or question marks).
Whatever Coldfusion's means of communication with the database, by default, it represents text meant for the browser in UTF-8.