As the name says, force the alter database to alter its collation ignoring the error message that I get from functions or calculated columns that compare data.
Is there a way to do so?
Like IGNORE_ERRORS or something like that? Thanks a lot!
A:
Maybe you can use transactions.
begin transaction;
alter table ...
... repair calculated colums ...
commit;
Normally it should not be possible that you can make changes to your database which leave it in an inconsistent state. See ACID
Daniel Engmann
2010-05-31 14:34:20
A:
No, because your data and database will be broken if you could ignore errors. Which is bad thing.
See this recent question about changing collation for inspiration, hopefully
gbn
2010-05-31 14:41:57
Thanks for the downvote: you still can't corrupt the database though...
gbn
2010-05-31 19:18:57
We sometimes have to do bad things to achieve good ones, you know? Still, I could find an interesting KB on the other topic you mentioned, so I'm giving you the answer.
Felipe Fiali
2010-06-01 12:41:05