Manuele Piastra wrote:
> On 24 Apr, 10:24, "Rik Wasmus" <luiheidsgoe...@hotmail.com> wrote:
>> On Thu, 24 Apr 2008 10:20:43 +0200, Manuele Piastra <manu...@gmail.com>
>> wrote:
>>
>>
>>
>>> I'm trying to create a trigger on a mysql 5 database. Here follows the
>>> script:
>>> CREATE TRIGGER awbparposinsert AFTER INSERT ON awbparzialipos
>>> FOR EACH ROW BEGIN
>>> INSERT INTO tabdogins(awbparzialeId, house, colli, peso, data,
>>> posmag, origId, origtipo) values( new.awbparzialeId, new.house,
>>> new.colli, new.peso, CURDATE(), new.codPosMagazzino, new.id, 'P');
>>> INSERT INTO tabdoggia(awbparzialeId, house, colli, peso, data,
>>> posmag) values(new.awbparzialeId, new.house, new.colli, new.peso,
>>> CURDATE(), new.codPosMagazzino);
>>> END;
>>> I get this error message:
>>> Unknown column 'new.awbparzialeId' in 'field list'
>> What columns does the table awbparzialipos have?
>
> adding SET NAMES utf8; on top of the create trigger command
> it works....

Is that so? Seems strange to me as there are no 'special' characters,
all ascii,,,,

> thank you so much

Well, glad to have been of help apparantly?

--
Rik Wasmus