thanks for your reply.

> > that i'm coming at this from cfmx (jdbc drivers) not purely java,

> by default driver and database server use encoding NONE, that
> means "what you get is what was saved" (driver uses String.getBytes()
> and new String(byte[]) methods to serialize/deserialize data,

unfortunately, using cfmx, passing in utf-8 text gets trashed *in* the
database, ie the debug info shows it being passed in fine. when i return it
from firebird its trashed (all ?????). used "none" for text charset. no joy.

> get same result all the time, you better specify character set for
> database and for driver using lc_ctype property.

yes i guessed thats what i needed.

> jdbc:firebirdsql:localhost/3050:c:/database/my.gdb?
> lc_ctype=UNICODE_FSS

unfortunately cfmx (coldfusion MX runs on top of jrun4) doesn't like that
style of parameter passing. any ideas?



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.375 / Virus Database: 210 - Release Date: 10/7/2545