Hi Erland,
I had the issue with special character '@' symbol. while i try to use in save the column. if my email id like - "[email protected]" means, my database table will shows as ="almubarak.hrigmail.com.
Can you please help me to figure out the issue. when i receive SMS message from any mobile. this things also happening. i already use the below code to URL encoding ensures that all browsers will correctly transmit text in URL strings.
Here is my code :
-----------------------------------
Server.UrlDecode(Convert.ToString(dr["message_received"]))
-------------------------------------------
Please help me to resolve the issue soon as possible. Any help will be greatly appreciated.
Thanks in advance.
Loading
AL MUBARAKPosted Jun 23, 2012, 2:01 AM
Saving the data's using parameter queries. and i just read the stored data with data reader in the table columns.
Here like I'm using the code :
Report += "
I'm using the code to use the store the data using SP - like below,
@mobile_no VARCHAR(50) = NULL,
@message_received NVARCHAR(MAX) = NULL,
I hope you understands now. the thing is server not Decode the actual data with special characters while storing the data. Can you please advise me that, is there any soemthing wrongly declare in SP or server side coding part.
Waiting for your kind reply.
Suthish NairPosted Jun 21, 2012, 1:28 PM