Re: Double byte datatype

une 01, 2001 1:29 AM Subject: RE: Double byte datatype > > I am having problem to update/insert record into a database in MS > > SQL 7.0 using store procedure. > > Some fields /parameters of the store procedure are of nvarchar, > > ntext, nchar > > data type. Is there a

Re: Double byte datatype

looct - Original Message - From: "Bryan Love" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 01, 2001 12:36 AM Subject: RE: Double byte datatype > when passing characters to a stored proc (NOT using CFSTOREDPROC) all string >

RE: Double byte datatype

> I am having problem to update/insert record into a database in MS > SQL 7.0 using store procedure. > Some fields /parameters of the store procedure are of nvarchar, > ntext, nchar > data type. Is there any CFSQLType or CF functions that supports > these datatype? > Is there any work around meth

RE: Double byte datatype

when passing characters to a stored proc (NOT using CFSTOREDPROC) all string types such as varchar, char, nvarchar, etc... should be surrounded by single quotes and all numeric types should not. nvarchar should be treated just like varchar, nchar should be treated just like char, and so on...