I have a table with a couple of TEXT columns. In one of them, there are
characters that aren't supported by the application and don't seem to be
able to display in the Query Analyzer either. I would like to:
1) remove these characters. (at least one of them for instance, is a "smart
quote" according to the application.
2) prevent them from being inserted at the database level (some kind of
a check constraint?) The application doesn't seem to check when it inserts,
but blows up when it tries to read them.
Any suggestions?
Thanks,
Jer Smith
characters that aren't supported by the application and don't seem to be
able to display in the Query Analyzer either. I would like to:
1) remove these characters. (at least one of them for instance, is a "smart
quote" according to the application.
2) prevent them from being inserted at the database level (some kind of
a check constraint?) The application doesn't seem to check when it inserts,
but blows up when it tries to read them.
Any suggestions?
Thanks,
Jer Smith