Oracle8i International language support question

Our application will need to support US and British Pound. If we store £ (the british pound sign) in oracle8i in a varchar2 field, it returns a # instead of £. We found that we could get around this by altering the session before we do the select on that varchar2 field. But I just wonder if we can have this capability database-wide for all sessions so that no alter session is needed. So when we have $, it will return $. If we have £, it should return £. The database can have these two currency symbols at the same time.

Does anyone know how to fix this problem?

Thanks in advance,
Morris

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Sep 18 2000 - 19:01:34 CDT