Quote:
Originally Posted by
hicksd8
This is all good... but I want to focus bottom up... only on the specific chars causing a problem in our DB.
That is what I am doing now ... finding the exact offending char and then finding the correct transform to cleanse it.
Please hold off on posting links unless the link contain solutions for the exact char we are having issues with (let's stick to bottoms up approach, not top down, for now).
I have all the chars we have found so far covered, so hold off (on these funny chars) until I get the various staging DBs synced.
Thanks.
Right now I have all the transforms I need based on what we have found so far. We can search for more in the next round. In other words, I know what the problem is. What we need is to find them and then fix them, from a bottoms up approach because I am not going to run any code which "transforms" problems we have not identified and tested. I do not want unintended consciences of running code and others transforms unless they solve a specific, clearly identified issue.
Will update soon.