Lucee supported SQL TYPES

there doesn’t seem to be a list of supported sql types in the documentation anywhere?

SQLCaster.java has the CF_SQL types in GitHub if anyone wants to copy and paste to docs.

fancy getting your hands dirty with the docs?

I will try this weekend.

2 Likes

I’ve added CFSQL types into lucee docs

thanks, they are live

Should it also be noted that the cf_sql prefix is not required,

cfsqltype="varchar" etc...

or that instead of cfsqltype can be replaced with type,

type="varchar" etc...

Would you like to submit a PR? :slight_smile:

It already shows up in the docs Query Handling In Lucee but without explanation.
your call on a PR.

the docs can always be improved! I think it would be useful addition to that page