|
Hi all,
I’m working with MySQL 5.0.22 and Reactor and have run into an issue with maximum length.
Basically I am getting errors that cfqueryparam length has been exceeded on creates. The field lengths mentioned in the errors did not look correct so I went hunting.
It looks like reactor is pulling out CHARACTER_MAXIMUM_LENGTH to use in cfqueryparam. This makes sense but when I look at the information_schema.columns table it appears that CHARACTER_OCTET_LENGTH holds the correct value.
If I create a table with some fields like CFID varchar(10), CFTOKEN varchar(64) I see the following in information_schema.columns:
CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH
CFID 3 10 CFTOKEN 21 64
Octect_length has the right values. I have read that there was a bug in MySQL 5.0.15 where these columns were reversed incorrectly. Still, I have no idea how the max_length values above have come about.
I can change the reactor code to pull out octect_length. Anyone else running 5.0.22 and seeing the same thing??
Thanks Angus
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- |
