Bug #28328 wrong type of charset in connector .NET
Submitted: 9 May 2007 7:38 Modified: 12 Jun 2007 9:48
Reporter: ilias iliadis Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / NET Severity:S1 (Critical)
Version: OS:Windows
Assigned to: CPU Architecture:Any
Tags: sql command to create table

[9 May 2007 7:38] ilias iliadis
Description:
connector can not find field name (because of wrong charset internally used?
).
It returns column names in some other charset than field values (which are correct)

How to repeat:
create database and table in mysql 5.0.x
with attached (in the next message) sql text file
use vb.net express edition to create a connection and then use 
the attached (in the next message) code to view in console the returned strings.
text was too big to be included here
[9 May 2007 7:42] ilias iliadis
sql to create database table:

-- MySQL dump 10.11
--
-- Host: localhost    Database: genika
-- ------------------------------------------------------
-- Server version	5.0.38-Ubuntu_0ubuntu1-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--added manualy start
DROP DATABASE IF EXISTS genika;
CREATE DATABASE genika;
use genika;
--added manualy end

--
-- Table structure for table `χρήστες`
--

DROP TABLE IF EXISTS `χρήστες`;
CREATE TABLE `χρήστες` (
  `χρηστης` char(15) NOT NULL default '',
  `ονομα` char(50) default NULL,
  `επωνυμο` char(50) NOT NULL default '',
  `επιπεδο` char(1) NOT NULL default '',
  `passwd` char(32) character set utf8 collate utf8_bin NOT NULL default '',
  `ειναιμεσα` int(11) default NULL,
  PRIMARY KEY  (`χρηστης`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `χρήστες`
--

LOCK TABLES `χρήστες` WRITE;
/*!40000 ALTER TABLE `χρήστες` DISABLE KEYS */;
INSERT INTO `χρήστες` VALUES ('care1a','ΟΝΟΜΑ','ΠΛΗΡΟΦΟΡΙΕΣ','1','182be0c5cdcd5072bb1864cdee4d3d6e',1005),('care2a','ΕΠΩΝΥΜΟ','ΕΙΣΑΓΩΓΕΣ1','2','182be0c5cdcd5072bb1864cdee4d3d6e',1006),('care2b','ΕΠΩΝΥΜΟ','ΕΙΣΑΓΩΓΕΣ2','2','182be0c5cdcd5072bb1864cdee4d3d6e',1006),('care2c','ΕΠΩΝΥΜΟ','ΕΙΣΑΓΩΓΕΣ3','2','182be0c5cdcd5072bb1864cdee4d3d6e',1006),('care2d','ΕΠΩΝΥΜΟ','ΕΙΣΑΓΩΓΕΣ4','2','182be0c5cdcd5072bb1864cdee4d3d6e',1006),('care3a','ΕΠΩΝΥΜΟ','ΕΞΙΤΗΡΙΑ1','3','182be0c5cdcd5072bb1864cdee4d3d6e',1006),('care3b','ΕΠΩΝΥΜΟ','ΕΞΙΤΗΡΙΑ2','3','182be0c5cdcd5072bb1864cdee4d3d6e',1006),('care3c','ΕΠΩΝΥΜΟ','ΕΞΙΤΗΡΙΑ3','3','182be0c5cdcd5072bb1864cdee4d3d6e',1006),('care3d','ΕΠΩΝΥΜΟ','ΕΞΙΤΗΡΙΑ4','3','182be0c5cdcd5072bb1864cdee4d3d6e',1006),('care3e','ΕΠΩΝΥΜΟ','ΕΞΙΤΗΡΙΑ5','3','182be0c5cdcd5072bb1864cdee4d3d6e',1006),('care4a','ΤΑΜΕΙΑ','ΙΚΑ1','4','182be0c5cdcd5072bb1864cdee4d3d6e',1006),('care4b','ΤΑΜΕΙΑ','ΔΙΑΦΟΡΑ1','4','f7177163c833dff4b38fc8d2872f1ec6',1006);
/*!40000 ALTER TABLE `χρήστες` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2007-05-09  5:26:49
[9 May 2007 7:45] ilias iliadis
vb.net  express edition code

Attachment: connectorbug2.txt (text/plain), 13.11 KiB.

[9 May 2007 7:47] ilias iliadis
sql command to create database+table

Attachment: xristes.sql (text/x-sql), 3.12 KiB.

[10 May 2007 12:24] Tonci Grgin
Hi Ilias and thanks for your report. What is your c/NET and NET FW version?
[10 Jun 2007 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[11 Jun 2007 8:09] Tonci Grgin
Hi Ilias. I still need the information requested...
[11 Jun 2007 8:35] Tonci Grgin
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

Explanation: This is a duplicate of Bug#25385. Seems the problem is related to computer configuration as Reggie is unable to reproduce it.
[12 Jun 2007 9:48] ilias iliadis
Sorry for the delay but since connector couldn't be used I returned to the good old vb 6.00 with ado and for some test projects i now use ado.net
The mysql server was in an ubuntu server
The connector was an XP SP2 proffessional Greek. (and was the latest version at that moment)
Nothing to do with the computer configuration since none of the other approaches (ado.net with vb.net or adodb with vb6.00) has the same problem.