Skip navigation links

MySQL Forums :: Triggers :: Trriger which converts characters


Advanced Search

Trriger which converts characters
Posted by: xxx xxx ()
Date: November 06, 2009 09:12AM

Hi,
I develope trigger which converts polish liters, remove spaces and return lowercase string into column "url".
My trigger executes correctly few times but until the moment I don't know why but it stop converts liters and remove spaces but trigger return lowercase string. When I drop and recreate this trigger it works perfect but still until the moment.
Source:
CREATE TRIGGER plurl BEFORE INSERT
ON artykul FOR EACH ROW
Begin
SET @a = replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(
lower(new.nazwa),

'ą', 'a'), 'ś', 's'), 'ę', 'e'), 'ż', 'z'), 'ź', 'z'), 'ć', 'c'), 'ń', 'n'), 'ł', 'l'), 'ó', 'o'), ' ', '_');
set new.url = @a;
End;

Options: ReplyQuote


Subject Views Written By Posted
Trriger which converts characters 164 xxx xxx 11/06/2009 09:12AM


Sorry, only registered users may post in this forum.