Actually, the separator becomes a null character (char zero), not a text mark....
On Wed, 2004-08-11 at 17:31, Geoffrey Mitchell wrote: > OK, this is a strange one: > > Platform: UV 10.0.16 / HP-UX 11.11 > > I have an SQL table with a multi-part primary key for which I have > specified an alternate separator (dealing wiht those text marks in the > key is annoying). > > This works fine...until I create a trigger (any insert/update trigger, > at least...have not tested exhaustively) on the table. While the > trigger is there, it inserts the records with text mark separators > instead of my alternate separator. If I drop the trigger, the problem > goes away. > > Has anyone else witnessed this? > > -- > Geoffrey Mitchell 314-684-1062 > Programmer/Analyst [EMAIL PROTECTED] > Knights Direct -- Geoffrey Mitchell 314-684-1062 Programmer/Analyst [EMAIL PROTECTED] Knights Direct ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/