June 25, 2007

derby does unicode

no idea why but i only just now got around to testing coldfusion 8's embedded derby database for unicode support. first thing i did was create a db using ben's going-to-get-even-easier advice to create a db in derby. i got a bit freaked out when i tried to create a table to test unicode strings using an Nvarchar data type and derby spit back a Feature not implemented: NATIONAL CHAR VARYING error. that started me scratching my head for a few minutes while it slowly dawned on me that derby is a java based db and unicode would be native to it. changed the Nvarchar to a plain varchar datatype and bob's your uncle.

very nice indeed.

June 01, 2007

coldfusion 8 minor flex annoyance

if any of your coldfusion 7 CFC methods have a return type of "any" these will probably fail in coldfusion 8 and flex w/the dreaded TypeError: Error #1009: Cannot access a property or method of a null object reference error. the public beta seems to have made type conversions to flex more "rigorous". you should also watch out for cases where your return type is "struct" and you're really returning a typed object, cf8 will blast away all the object bits & turn the returned object into a real coldfusion structure (ie your object's key case will become UPPER case and since flex is case sensitive this will lead to a certain amount of head scratching). in almost all the cases i've looked at both of these cases were simply sloppy coding/QC (majority were left over from my dithering around about exactly what to return to flex, "any" worked well in those cases ;-) & could be "fixed" in a few seconds.

while it's a short term annoyance i think this is probably for the better long term.

Labels: ,