Select special characters

[nirasha]

I have successfully done a conversion of the characterset (via the alter database statement).

We are now looking for values that were already stored in the old format (eg the accent was stored like a block). We are considering using the chr() function to seach the field for any characters higher that chr(127) since we converted from us7ascii to WE8MSWIN1252.

Any help into the sql statement or alternative methods would be greatly appreciated.

Thanks in advance

[rpardip]

Could you please give me the process of how you did this
conversion? Detailed info. would be appreciated.

Thanks in advance!

[nirasha]

I think I might have said it wrong. I meant I converted the storage format of the db. And I did it like:
1. Ensure that the parallel_server is set to false in the init.ora file
o svrmgrl
o connect internal
o startup mount;
o alter system enable restricted session;
o alter system set job_queue_processes=0;
o alter database open;
o alter database character set WE8MSWIN1252;
o shutdown immediate;
o startup restrict;
8. Restore the parallel_server parameter in the init.ora file if you changed it.
9. A double restart is necessary because of a SGA initialization bug, which is fixed in Oracle 9i. Perform the following in Server Manager:
o svrmgrl
o connect internal
o shutdown immediate;
o startup;

This works since I can store new values with special accents etc. Now I need help doing something like
selecting values from the table where one of the fields matches values chr(>=127)?????

Thanks.. if you have questions about the conversion, just ask.

Nirasha