bogdem
asked on
Bad sql characters!
Hello, All!
What characters needs to be replaced before insert in to DB ?
As I know it's
'
"
what else?
Thanks.
What characters needs to be replaced before insert in to DB ?
As I know it's
'
"
what else?
Thanks.
Only apostrophes. Double-quotes are fine.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
All even number of apostrophes ' , ''', ''''', etc. should be replaced
Those are odd.
Those are odd.
I'm not sure if it's the same with SQL Server, but I also has problems with pipes ( | ) in Access.
Dave.
Dave.