I am writing a web application and everytime I attempt to insert some special characters in the database I get errors. Is there a way around this?Depends what you mean. If you mean unicode and you are attempting to insert into CHar or VarChar fields then you need to use NVarChar or NChar. BoL has all the gory details. Otherwise you'll need to porovide more details.
HTH|||it seems everytime I include an apostrophe the system gives me an error..not sure why this is happening
my second question is-- when someone types this:
I cant wait
to leave
this place
--It come out like this
I cant wait to leave this place
How can I make the system print all the tab keys and return carriage?
thank you for any responses|||You need to escape apostrophes.
"I can't wait to leave this place"
must be submitted as
"I can''t wait to leave this place"
HTH|||The latter problem is probably a presentation issue - your FE needs to interpret the carriage returns & line feeds.|||hi everybody,
This is Rajen, hope it will be nice sharing ideas with u all. Feeling nice to join u all .:beer:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment