Urgent Problem with char(100) fields in mySQL

[Zero-G.]

Hey

Using your latest components for mySQL.

I have the following table structure:

Code: Select all

--Table: lieferanten

--DROP TABLE IF EXISTS lieferanten;

CREATE TABLE lieferanten (
  ID               bigint AUTO_INCREMENT NOT NULL,
  Lieferant        bigint NOT NULL,
  Anschrift1       char(100),
  Anschrift2       char(100),
  Strasse          char(100),
  PLZ              int(10),
  Ort              char(100),
  Land             char(100),
  FestVw1          char(100),
  FestTel1         char(100),
  FestVw2          char(100),
  FestTel2         char(100),
  FaxVw            char(100),
  FaxTel           char(100),
  MobilVw          char(100),
  MobilTel         char(100),
  EMail            char(100),
  Ansprechpartner  text,
  KdNr             char(100),
  Zeitstempel      timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  /* Keys */
  PRIMARY KEY (ID)
) ENGINE = InnoDB;

CREATE UNIQUE INDEX lieferanten_unique
  ON lieferanten
  (Lieferant);

When I try to insert some values, than I get the following output error:

Code: Select all

Einzelschritt: Devart.Data.Linq.DataContext.SubmitChanges-Methode ohne Symbole wird übersprungen.
INSERT INTO lieferanten (Lieferant, Anschrift1, Anschrift2, Strasse, PLZ, Ort, Land, FestVw1, FestTel1, FestVw2, FestTel2, FaxVw, FaxTel, MobilVw, MobilTel, EMail, Ansprechpartner, KdNr) VALUES (:p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10, :p11, :p12, :p13, :p14, :p15, :p16, :p17, :p18) 
-- p1: Input BigInt (Size = 0; DbType = Int64) [0]
-- p2: Input Char (Size = 7; DbType = AnsiStringFixedLength) [Versuch]
-- p3: Input Char (Size = 0; DbType = AnsiStringFixedLength) []
-- p4: Input Char (Size = 0; DbType = AnsiStringFixedLength) []
-- p5: Input Int (Size = 0; DbType = Int32) []
-- p6: Input Char (Size = 0; DbType = AnsiStringFixedLength) []
-- p7: Input Char (Size = 0; DbType = AnsiStringFixedLength) []
-- p8: Input Char (Size = 0; DbType = AnsiStringFixedLength) []
-- p9: Input Char (Size = 0; DbType = AnsiStringFixedLength) []
-- p10: Input Char (Size = 0; DbType = AnsiStringFixedLength) []
-- p11: Input Char (Size = 0; DbType = AnsiStringFixedLength) []
-- p12: Input Char (Size = 0; DbEine Ausnahme (erste Chance) des Typs "System.NotSupportedException" ist in Devart.Data.Linq.dll aufgetreten.
Eine Ausnahme (erste Chance) des Typs "System.NotSupportedException" ist in Devart.Data.Linq.dll aufgetreten.
Eine Ausnahme (erste Chance) des Typs "System.NotSupportedException" ist in Devart.Data.Linq.dll aufgetreten.
Type = AnsiStringFixedLength) []
-- p13: Input Char (Size = 0; DbType = AnsiStringFixedLength) []
-- p14: Input Char (Size = 0; DbType = AnsiStringFixedLength) []
-- p15: Input Char (Size = 0; DbType = AnsiStringFixedLength) []
-- p16: Input Char (Size = 0; DbType = AnsiStringFixedLength) []
-- p17: Input Text (Size = 0; DbType = String) []
-- p18: Input Char (Size = 0; DbType = AnsiStringFixedLength) []
-- Context: Devart.Data.MySql.Linq.Provider.MySqlDataProvider Model: am Build: 1.0.43.0

SELECT Zeitstempel FROM lieferanten WHERE ID = :ask
-- ask: Input BigInt (Size = 0; DbType = Int64) [142]
-- Context: Devart.Data.MySql.Linq.Provider.MySqlDataProvider Model: am Build: 1.0.43.0

Eine Ausnahme (erste Chance) des Typs "System.NotSupportedException" ist in Devart.Data.Linq.dll aufgetreten.
Einzelschritt: Microsoft.VisualBasic.CompilerServices.ProjectData.SetProjectError-Methode ohne Symbole wird übersprungen.

I played around and found out, that always the 10th value of type: DbType = AnsiStringFixedLength) []
got's this error

Please help - This is really urgent!

[StanislavK]

We couldn't reproduce the problem. I've sent you a test project in a letter, please check that it was not blocked by your mail filter.

Please specify what should be changed in the test project to reproduce the issue. Also, please specify the version of MySQL server you are using and the stack trace of the exception you are getting.