How to create a view ignoring data with foreign characters (Chinese)
Posted on 2011-10-06
We have to create a view or process a table from tables than contains mixed western european and chinese characters.
We do not want to remove the chinese characters from the data itself, we just want to blank them for an specific query / view.
The most general approach will be the best as today it is a problem with chinese characters and in the future with other languages as arabic.
The chinese characters are sometimes inside columns with westerna european chacarters. We just want to ignore the chinese chacters.
We have looked at regular expression, translate but we are struggling to make this work.