Oracle dataserver £ special character ¿

[Tony.Coventry]

We have an application which stores the pound symbol £ in a Progress database.

We then update an Oracle db using a set of APIs and the £ gets stored in Oracle as an upside down question mark ¿



Any ideas how we can get the pound sign into Oracle correctly?

 

[tamhas]

As they said on PEG, this is clearly an issue of getting all your code pages lined up and having any needed code page conversion tables in place.

 

[Tony.Coventry]

Thanks tamhas,

Any ideas on how to trace the code pages involved at each stage?
- I can set my 4GL/ABL client using the startup parameters (I'm trying this use ISO8859-1)
- How do I know what code page my Oracle Dataserver uses?
- I'm quite sure the Oracle Db uses ISO8859-1 too (see below)

I have run the following command from SQL*Plus against the Oracle db in question:

select * from nls_database_parameters;

which gave me the following result

NLS_CHARACTERSET WE8ISO8859P1


I don't know what the WE8 prefix means, but does this suggest that it shoudl be compatible with ISO8859-1?

 

[DevTeam]

NLS_CHARACTERSET WE8ISO8859P1


I don't know what the WE8 prefix means, but does this suggest that it shoudl be compatible with ISO8859-1?

It stands for Western Europe 8-bit ISO 8859.

When you create the dataserver schema, you're asked to enter a codepage. Maybe it is considered as the refenrence, even if your Oracle instance is correctly configured. But I have no idea how to check it...

EDIT : through the data dictionnary, with the "Change Dataserver schema codepage" option ?

 

[Tony.Coventry]

Thanks for that!

But now I'm utterly confused!! I went in to change the code page for the dataserver as you suggested (Data Administration -> Dataserver -> Oracle Utilities -> Change Dataserver Schema Codepage)

When prompted for the new code page it was pre-filled with iso8859-1

I would assume that means that it is already using iso8859-1?