SQL 2000 UK Pound Sign (£) Problem
Posted on 2009-05-06
I have a very peculiar problem. We have around 30 pcs running Delphi 6 bespoke software writing back to an SQL 2000 Database. This has all been working fine for years. The problem is that I have recently purchased a new PC (HP DC5800) and whenever a UK pound sign (£) is written back to the database from the new PC the £ sign is displayed as a S when accessed from any other PC and from Query analyzer on the SQL server. (This obviosly causes problems when other uses print out the data)
Conversly if the new HP DC5800 opens data containing a pound sign created from any other PC it shows the pound sign as a strange symbol that is best described as a U with a ^ on top.
All PCs are running windows XP SP3. I have checked the regional settings and they are all set to UK English. (It may be worth noting that originally the HP DC5800 was set to Welsh.)
All other symbols eg !"$%^&*()_+-= are working fine and can be stored and accessed correctly from any PC including the new one.
I am sure there must be an obvious solution but I can not find it!! Thank you in advance for any help. Please contact me if further info is required.