CFQUERYPARAM CFSQLTYPE Datatype Sizes?

[-=MM=-]

Hi,
This is probably come up before, but I'm not having any luck tracking
down info on it. Does anyone have a list of datatype sizes for each type
supported in the CFQUERYPARAM tag's CFSQLTYPE attribute (where applicable)?

Found this documentation:
[url]http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-b20.htm#wp1102474[/url]
But it doesn't go into any details around the datatypes themselves. Could the
sizes be driven by the database you are connecting to, or are they published in
some standard out there?

Thanks!
-=MM=-

[Jochem van Dieten **AdobeCommunityExpert**]

-=MM=- wrote:

> This is probably come up before, but I'm not having any luck tracking
> down info on it. Does anyone have a list of datatype sizes for each type
> supported in the CFQUERYPARAM tag's CFSQLTYPE attribute (where applicable)?
>
> Found this documentation:
> [url]http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-b20.htm#wp1102474[/url]
> But it doesn't go into any details around the datatypes themselves. Could the
> sizes be driven by the database you are connecting to, or are they published in
> some standard out there?

There is no standard, it is all implementation defined. Since the
cfsqltype datatypes map to the JDBC datatypes, your best bet is
checking the documentation of the JDBC driver of your database to
see the native datatype and the mapping and limitations.

Jochem

--
Jochem van Dieten
Adobe Community Expert for ColdFusion