Our Environment is Linuc 5.4 . Sybase 15.5
@@version ==> Adaptive Server Enterprise/15.5/EBF 19399 SMP ESD#5/P/x86_64/Enterprise Linux/asear155/2568/64-bit/FBO/Fri Dec 9 02:45:22 2011
Our "default character set id" is set to 1.
We noticed post our upgrade to sybas 15.5 from sybase 12.5.4 our text data columns specifically the ones which had ascii codes > 127 have got corrupted.
Example :- MSWord quote "’" now is stored as â ascii value 226 ....and this is true for all the ascii values > 126.
and if update the text data , it gives us even more garabe.
Also we are noticing if we try to insert new data into our text columns , which ascii > 127 , it also gets coruppted.
Question :- 1. How to restore our courrpted data back to what it was in the db prior 15.5
2. going forward how do we store data with special characters ascii > 127 into our database.