Strange _UTF Problem

Anyone saw this error? (never mind the usefullness of the query, simply p=
laying arround)

This query works fine:
select=20
c.Table_Catalog TableCatalog,=20
c.table_schema TableSchema,=20
c.TABLE_NAME TableName,=20
c.COLUMN_NAME ColumnName,=20
c.Column_Default ColumnDefault,=20
c.IS_NULLABLE IsNullable,=20
c.DATA_TYPE DataType,=20
c.CHARACTER_MAXIMUM_LENGTH MaxLength,=20
c.numeric_precision NumPrecision,
CASE WHEN (data_type =3D 'set')=20
then=20
-- Set value
trim(Trailing ')' from SUBSTRING(Column_Type, 5))
else=20
CASE WHEN (data_type =3D 'enum')
then=20
trim(Trailing ')' from SUBSTRING(Column_Type, 6))=20
else=20
''=20
end
end SetOrEnum
from=20
information_schema.columns c

However when creating a view based on the query it fails:

CREATE VIEW vAdmin_SelectColumns
AS=20
select=20
c.Table_Catalog TableCatalog,=20
c.table_schema TableSchema,=20
c.TABLE_NAME TableName,=20
c.COLUMN_NAME ColumnName,=20
c.Column_Default ColumnDefault,=20
c.IS_NULLABLE IsNullable,=20
c.DATA_TYPE DataType,=20
c.CHARACTER_MAXIMUM_LENGTH MaxLength,=20
c.numeric_precision NumPrecision,
CASE WHEN (data_type =3D 'set')=20
then=20
-- Set value
trim(Trailing ')' from SUBSTRING(Column_Type, 5))
else=20
CASE WHEN (data_type =3D 'enum')
then=20
trim(Trailing ')' from SUBSTRING(Column_Type, 6))=20
else=20
''=20
end
end SetOrEnum
from=20
information_schema.columns c

Then selecting the records from the view :
select * from vAdmin_SelectColumns gives me the error:

[Error] Script lines: 1-2 --------------------------
You have an error in your SQL syntax; check the manual that corresponds =
to your MySQL server version for the right syntax to use near '_utf8')') =
else (case when (`c`.`DATA_TYPE` =3D _utf8'enum') then rtrim(substr(`c`.'=
at line 1"=20

annyone?

Thx
************************************************************ *************=
***
Disclaimer:=20
This electronic transmission and any files attached to it are strictly=20
confidential and intended solely for the addressee. If you are not=20
the intended addressee, you must not disclose, copy or take any
action in reliance of this transmission. If you have received this=20
transmission in error, please notify the sender by return and delete
the transmission. Although the sender endeavors to maintain a
computer virus free network, the sender does not warrant that this
transmission is virus-free and will not be liable for any damages=20
resulting from any virus transmitted.=20
Thank You.
************************************************************ *************=
***

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org