I 'm sorry, I'm puzzled and I don't understand. We can insert pound signs
(#) ASCII ( 0x23 ) without any problem. We're using Informix 7.1 on an
HP 9000. I don't know of a DB_LOCALE environment variable. Are you talking about the pound as in the British currency unit? If so, what about DBMONEY? I get
some strange characters "2E" in the message below.
Many thanks.
Peter Wages
EDS
}
} If you want to have a pound sign in an insert statement, the default (US)
} locale won't do. You have to set DB_LOCALE appropriately at the time the
} database is created.
} -------
}
} Brian Wilkins.
}
} In article <62ih3r$pc@cssun.mathcs.emory.edu>, davin_harvey@dsti.co.uk ()
} wrote:
}
} > How do I do this? When I use the insert into =2E=2E=2E values =2E=
} > 2E=2E=
} > and have=20
} > a pound sign (ASCII 0xa3) as part of the insert, it gives me a -202
} > :=20
} > An illegal character has been found=2E I've tried different locale
} > s,=20
} > but no joy=2E
} > =20
} > Online V7=2E22 on AIX V4=2E1=2E3=2E
} > =20
} > Ta
} > Davin
} >
} > **********************************************************************
} > DST International Tel:+44 181 390 5000 www=2Edstinternational=2Eco=
} > 2Eu=
} > k=20
}
}