[mamba700]

OK I have it fixed now and runs fine.

Here is what needs to be done. The operation of UNION ALL requires that the fields are the same character set.

So check bots and character_ tables. Look in each field for the character set. Change the set to match the other table.

So Specifically i looked at 'Name' in table character_ and it shows character set = latin1 collation = latin1_swedish_ci

So I then go to the same field in table bots and change it to match. Once this was done the view was created with no errors.

I hope this helps other folks with the same problem.