"cfsqltype and nvarchar in sql server 2008"

I am using coldfusion and sql server 2008.

1) Cfprocparam we have cf_sql_varchar but nothing for nvarchar I have a lot of paramater to datatype nvarchar which cf_sql datatype should I use

2) do I use cf_sql_long_varchar for varchar (max)
sohairzaki2005Asked:
Who is Participating?
 
_agx_Connect With a Mentor Commented:
1) Cfprocparam we have cf_sql_varchar but  nothing for nvarchar I have a lot of paramater to datatype nvarchar  which cf_sql datatype should I use
Right. CF does not currently have an nvarchar type.  Use cf_sql_varchar. But be sure to enable the unicode setting in your DSN
http://www.sustainablegis.com/blog/cfg11n/index.cfm?mode=entry&entry=F9553D86-20ED-7DEE-2A913AFD8651643F

2) do I use  cf_sql_long_varchar for varchar (max)
Yes.  It the replacement the deprecated long "text" type.
http://msdn.microsoft.com/en-us/library/ms378715.aspx 
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_p-q_18.html 
0
 
Gurpreet Singh RandhawaWeb DeveloperCommented:
for ur nvarchar you can use the

cf_sql_longvarchar or you can use <cfqueryparam name="something" cfsqltype="cf_sql_clob" maxlength="2147483647">

or

<cfqueryparam name="something" cfsqltype="cf_sql_longvarchar">

0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
sohairzaki2005Author Commented:
That means it will automatically recognize the unicode characters
0
 
Gurpreet Singh RandhawaWeb DeveloperCommented:
yes it will it automatically handles the data..
the link i gave you have explanation t!
0
 
sohairzaki2005Author Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.