With Paul help I have the problem resolved. There is a check box in CF Admin, for a datasource where you can force to use unicode strings. Once that one was checked the <cfqueryparam properly saved the info. Putting N in front of the string to be inserted is forcing the string to be unicode.
I think it will be wise if MM will add that as a note in the <cfqueryparam docs. thanks Marius ----- Original Message ----- From: "Jochem van Dieten" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, January 31, 2003 5:11 AM Subject: Re: cfqueryparam and unicode > Marius Milosav wrote: > > Paul I have tried you example and I have the same result as before. > > > > With N'#text#' is working (with or without cfprocessingDirective) > > with <cfqueryparam is failing (with or without cfprocessingDirective) > > > > CFMX has updater 2 (version 6,0,0,55693) > > Which driver? > > Jochem > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4