On Thu, 7 Jan 2010 15:48:24 +0200, "machiel.richards" <machiel.richa...@gmail.com> wrote:
> Hi All > > What the Oracle guys found was that some of the fields were blank even > though the fields were configured as not nullable. > > I found that where this is the case, the users entered a blank space > which is then counted as a character and is thus not null. > > This is causing all kinds of havoc for them as Oracle apparently still > sees this as nulls. I'm not sure what export method you're using, but you should be able to fix this by specifying to quote fields. Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org