special char to stored procedure parameters

hem969 · May 23rd, 2007, 02:39 PM

Hi,

I want to assign stored procedure parameter values from a a string containing special characters like ciÃ©tÃ©, ''. The coding is in ASP.
Also in database table values are stored with special characters.

its giving me error at Set rs = cmd.Execute()

any idea how to send special characters string through stored procedure?

Thanks
Hem

happygv · May 28th, 2007, 05:18 AM

Hem,

Your post doesn't give sufficient information for troubleshooting your problem. How about posting the code relevant to construct of procedure call in ASP?

_________________________
- Vijay G
Strive for Perfection

sshelper · May 29th, 2007, 11:40 AM

Make sure that the data type of your parameter in your stored procedure is defined as either NCHAR or NVARCHAR, if this is SQL Server. If this is not SQL Server, just make sure that the parameter data type can handle Unicode characters.

SQL Server Helper
How well do you know SQL? Find out with the free test assessment from SQL Server Helper!!!
http://www.sql-server-helper.com/free-test/default.aspx

Got a SQL Server Question? Ask us here: http://www.sql-server-helper.com/forums/default.asp