<p>Does anyone know of a way to store values as NVARCHAR in a manually created query in ColdFusion using the querynew() function?  I have multiple parts of a largish program relying on using a query as an input point to construct an excel worksheet (using Ben's POI) so it's somewhat important I can continue to use it as a query to avoid a relatively large rewrite.</p>

<p>The problem came up when a user tried storing something that is outside of the VARCHAR range, some Japanese characters and such.</p>

<p>Edit: If this is not possible, and you are 100% sure, I'd like to know that too :)</p>

The only thing I've been able to come up with so far is this:
```
```
<cfset x = QueryNew("foobar")/>
<cfset queryAddRow(x) />
<cfset querySetCell(x, "foobar", chr(163)) />
<cfdump var="#x#">
```
```
When dumped, this query does contain the British Pound symbol.
I haven't tried this with Ben's POI utility, but hopefully it helps you some.