I have two different content in **view db**, in where this **view db** is generated from **table db**. 

there are two columns here from table

```
(CASE WHEN view.dcs = 8 then view.uc2content else view.utf8content END) as 'dcsContent'

```

uc2content and utf8content are surely two different encoding character, which I create to a view using this query 

```
CONVERT(a.textcolA USING utf8) as utf8content,
CONVERT(a.textcolb USING ucs2) as uc2content,

```

Any idea how to get rid of this `mix-of-collations`?

Thanks in advance