Re: Question mark becomes NULL

2003-02-24 Thread Daneman
At 15:45 24-2-03 -0500, Keith C. Ivey wrote: On 24 Feb 2003, at 21:07, Daneman wrote: > INSERT INTO MyTable (MyFields) VALUES ($val1, $val2, etc); > > Question marks are no longer replaced with NULL values in the text > column this way, still, when I enter question marks into the char

Re: Question mark becomes NULL

2003-02-24 Thread Daneman
At 14:25 24-2-03 -0600, gerald_clark wrote: And you still have not shown us how you are entering the question marks. Like this: $sql = qq{ INSERT INTO main (id, categorie, achternaam, voornaam, aanspreektitel, straat, huisnummer, postcode, plaatsnaam, telefoon, mobiel, email1, email2, tekst) VAL

Re: Question mark becomes NULL

2003-02-24 Thread Daneman
At 10:06 24-2-03 -0500, Keith C. Ivey wrote: On 24 Feb 2003, at 13:42, Daneman wrote: > I use a perl script & DBI to insert records into a mySQL database. > This database holds 1 text-column. Now when this text-field holds any > question marks, they appear in the record as`NULL`.

Question mark becomes NULL

2003-02-24 Thread Daneman
Greetings, I have this strange problem. I use a perl script & DBI to insert records into a mySQL database. This database holds 1 text-column. Now when this text-field holds any question marks, they appear in the record as`NULL`. I went thrue the mySQL docs to find out how to avoid this but to