cfqueryparam and mssql

> I know the defualt CFSQLTYPE is CF_SQL_CHAR. Most of my fields are nvarchar,
> so would I HAVE to use CF_SQL_VARCHAR? Or would CF_SQL_CHAR work as well?

You should use VARCHAR. The CHAR / VARCHAR thing is to do with the size of
the storage, not what's being stored. A CHAR field occupies the size
specified, irrespective of what you put in it. If you ahve a CHAR(10) and
put 'A' in it: it still uses 10 bytes. In a VARCHAR(10) it would only take
one byte.

That said, from a JDBC perspective, I'm pretty sure it wouldn't matter,
because I think the validation done is just for type of data (and both are
character data) and size (and as long as it's within the max you specify:
fine). And the unicode-ness of the data doesn't seem to come into it
either. Someone might correct me on that.

But even if either would work, I think VARCHAR is more sensible because
it's the closest to the real situation.

--
Adam

jeremy@noble wrote:
> I'm a little confused about using cfqueryparam:
>
> I know the defualt CFSQLTYPE is CF_SQL_CHAR. Most of my fields are nvarchar,
> so would I HAVE to use CF_SQL_VARCHAR? Or would CF_SQL_CHAR work as well?

use varchar & make sure you set the "Enable High ASCII characters and Unicode
for data sources configured for non-Latin characters" under advanced settings
for that dsn.