Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

SQL 2000 UK Pound Sign (£) Problem

Avatar of RICHARDWSMITH
RICHARDWSMITH asked on
Microsoft SQL ServerDelphiWindows XP
7 Comments1 Solution795 ViewsLast Modified:
Hi there,

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.

Regards,
Richard
ASKER CERTIFIED SOLUTION
Avatar of meispisces
meispiscesFlag of India image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 7 Comments.
See Answers