Corrupted Data

[net]

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.

[TomBez]

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 ” “.

[peterlaursen]

http://www.sightspecific.com/~mosh/WWW_FAQ/nbsp.html

and the fund of the day: http://www.trygve.com/doomsday.html

http://www.sightspecific.com/~mosh/WWW_FAQ/nbsp.html

and the fund of the day: http://www.trygve.com/doomsday.html

[Author]

Posts