Trigger on Multilingual DB.

Posted in 2006

vratesh — 10 Sep 2006 22:34:48 -0700 — source: Usenet: comp.databases.informix

hi.. I wanna create a trigger on to update a table in a normal database if a table in another multilingual database is updated. Source database -> Inofrmix 9.4 (DB_LOCALE=EN_US.UTF8) Sink database -> Inofrmix 9.3 (DB_LOCALE=EN_UTF.819) The problem while creating the trgger is following: 23197: Database locale information mismatch. CREATE TRIGGER tran_triggerINSERT ON cns_vc@ifx940fc6w1:test_2 REFERENCING NEW as new FOR EACH ROW ( insert into test_vc@ifx930_2vb:test values(new.a) ); Pls suggest some way out!!! Thanks in advance ! Vratesh