Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Corrupted Data

forums forums SQLyog Using SQLyog Corrupted Data

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • #9643
      net
      Member

      Hi! I have an ASP.NET application that use the CorelLab driver to connect to MySQL. I'm using the SQLyog application to work on the database.

      I have an table where I put in one userName type for a customer, one userName type varChar for a seller and an bookId for a book to be sold.

      Everything in the application (and database) works fine except this one table. When I instert the customerUsername it works fine, and the bookId too.

      But when I try to insert the username for the seller I get ” “. This is the code for “space” it seems when searching the internet. What could be the reason?

      It worked fine when I used SQL server.

    • #21420
      TomBez
      Member
      net wrote on Apr 25 2006, 02:39 PM:
      But when I try to insert the username for the seller I get ” “. This is the code for “space” it seems when searching the internet. What could be the reason?

      Most likely it is because you might have a trailing space in the input-field in your web-application, or you haven't entered any name. another possibility is, that the asp.net application does not read the input-field correctly and assumes a default-value or something like that.

      have you tried to update or insert data in your table with SQLyog manually? check also if the default value of the field “username” in your database is set to ” “.

    • #21421
      peterlaursen
      Participant
Viewing 2 reply threads
  • You must be logged in to reply to this topic.