I have a legacy Java program that outputs an SQL script. I then use Apache Derby to run that SQL on the target database (which is not on the same server as CRON).
When run via putty, this works fine. When run in windows this works fine. When run using CRON, Derby reads £ signs as ?.
If I look at the sql script generated (using VI), it contains the £ signs. If I check the database however, it contains ?.
Why would running this under CRON make the program behave any differently?