Just to be clear: The code page that the database and the client (could be the AppServer, a development or run time session) use don't necessarily need to be the same, especially if the database uses unicode (UTF-8). If the code pages are not the same then they must either be compatible (share the the same character set but on different positions, for example iso8859-1 and imb850, Progress will automatically do the conversion for you) or you must roll your own conversion. When you look at a compile procedure running against a database there are possibly several different code page settings involved: The database, the run time session and the code page under which the .r file was compiled (which is relevant to all hard coded texts). In an ideal world they are all the same but sometimes they are not. At least the code page of the run time session and the one under which the .r file was compiled should be the same.
Heavy Regards, RealHeavyDude.