In the Application.cfm I have the following: <cfcontent type="text/html; charset=euc-kr"> <cfset setEncoding("URL", "euc-kr")> <cfset setEncoding("FORM", "euc-kr")>
using MS-SQL 2000 sp 3 the column is declared as nvarchar if ??/?? (which is Korean) is entered in the corresponding form filed and then the form is saved: using: INSERT INTO messages ( test ) VALUES ( N'#form.test#' ) </cfquery> The information is saved and display properly on the other hand if the following is used INSERT INTO messages ( test ) VALUES ( <cfqueryparam cfsqltype="cf_sql_varchar" value="#form.test#"> ) </cfquery> the information is not saved properly and the display shows only ???? So obviously I am missing something Marius ----- Original Message ----- From: "Jochem van Dieten" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 30, 2003 5:03 PM Subject: Re: cfqueryparam and unicode > Marius Milosav wrote: > > Can you give me an example or a pointer. > > Using PostgreSQL: > <cfquery> > INSERT INTO messages ( > test > ) > VALUES ( > <cfqueryparam > cfsqltype="cf_sql_varchar" > value="-濯Yの, म^, .ाँs -ा स. Τfιάμαλο,"> > ) > </cfquery> > > 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4