derby does unicodeno 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.