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
