Server version: 5.1.31-log MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> set names utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from bug47985;
Field   1:  `Id`
Catalog:    `def`
Database:   `test`
Table:      `bug47985`
Org_table:  `bug47985`
Type:       LONG
Collation:  binary (63)
Length:     10
Max_length: 0
Decimals:   0
Flags:      NOT_NULL PRI_KEY UNSIGNED AUTO_INCREMENT NUM PART_KEY 

Field   2:  `VCCol`
Catalog:    `def`
Database:   `test`
Table:      `bug47985`
Org_table:  `bug47985`
Type:       VAR_STRING
Collation:  utf8_general_ci (33)
Length:     36
Max_length: 0
Decimals:   0
Flags:      BINARY 


0 rows in set (0.00 sec)

mysql> create view vbug47985 as select * from bug47985;
Query OK, 0 rows affected (0.01 sec)

mysql> select * from vbug47985;
Field   1:  `Id`
Catalog:    `def`
Database:   `test`
Table:      `vbug47985`
Org_table:  `vbug47985`
Type:       LONG
Collation:  binary (63)
Length:     10
Max_length: 0
Decimals:   0
Flags:      NOT_NULL PRI_KEY UNSIGNED AUTO_INCREMENT NUM PART_KEY 

Field   2:  `VCCol`
Catalog:    `def`
Database:   `test`
Table:      `vbug47985`
Org_table:  `vbug47985`
Type:       VAR_STRING
Collation:  utf8_general_ci (33)
Length:     36
Max_length: 0
Decimals:   0
Flags:      BINARY 


0 rows in set (0.00 sec)

mysql> show variables like "%char%";Field   1:  `Variable_name`
Catalog:    `def`
Database:   ``
Table:      `VARIABLES`
Org_table:  ``
Type:       VAR_STRING
Collation:  utf8_general_ci (33)
Length:     192
Max_length: 24
Decimals:   0
Flags:      NOT_NULL 

Field   2:  `Value`
Catalog:    `def`
Database:   ``
Table:      `VARIABLES`
Org_table:  ``
Type:       VAR_STRING
Collation:  utf8_general_ci (33)
Length:     3072
Max_length: 32
Decimals:   0
Flags:      


+--------------------------+----------------------------------+
| Variable_name            | Value                            |
+--------------------------+----------------------------------+
| character_set_client     | utf8                             | 
| character_set_connection | utf8                             | 
| character_set_database   | utf8                             | 
| character_set_filesystem | binary                           | 
| character_set_results    | utf8                             | 
| character_set_server     | utf8                             | 
| character_set_system     | utf8                             | 
| character_sets_dir       | /opt/mysql/mysql/share/charsets/ | 
+--------------------------+----------------------------------+
8 rows in set (0.00 sec)

mysql> 

--------
Test case result:
Command text:
SET character_set_results=NULL
====== End of Query ======

T DataTypeName(1): VARCHAR
T GetFieldType(1): System.String
WindowsFormsApplication1.vshost.exe Information: 0 : [12.10.09 14:31:44] - 
====== Query logged ======
Time of query: 12.10.09 14:31:39
host: opensol
time of execution: 0.0003989 seconds (0.3989 milliseconds
-- Result --
UA Warning: some fields not accessed (Id, VCCol)
Command text:
SELECT * FROM bug47985
====== End of Query ======

V DataTypeName(1): VARCHAR
V GetFieldType(1): System.String