Link to home
Start Free TrialLog in
Avatar of bogdem
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.
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Only apostrophes.  Double-quotes are fine.
ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
All even number of apostrophes ' , ''', ''''', etc. should be replaced

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.