CAMPBELL, BRIAN D (BRIAN) [mailto:[EMAIL PROTECTED] wrote:
> I'm guessing that when a field is empty in your CSV file, then the method > $csv->fields puts an empty string value (e.g. "") in the corresponding > element in your @data array (not an undef value). > > If so, you are going to have to detect for this condition and change it to > an undef before binding with bind_param. Undef will cause a null to be > inserted. In general, you would need to do this to all fields that you > want to represent as null, when they are represented as empty fields in > the CSV input. I'm used to Oracle, which treats an empty string as NULL. Is it different for MySQL? Ronald
