Hello

I've large data in a table in which one of the columns is description. in this column i'm to store description of materials and their tolerance which is a (+/-)ve value.
for sample:18K 1/4W ±1%. while restoring the data on a test system i observed a special character before the ± symbol like 18K 1/4W±1%. this is the case with all the 3000+ rows of data. is there any means of deleting or eliminating the special character instead of manually deleting it from each cell data manually.

thank you before hand.

Chaitanya.

Use the replace function:

update theTable set theField = replace( theField, '±', '±');

Obviously your interfaces got mixed up with UTF-8 and other encodings.

commented: this reply solved my issue +0

Use the replace function:

update theTable set theField = replace( theField, '±', '±');

Obviously your interfaces got mixed up with UTF-8 and other encodings.

this solved my issue and yes you are right, the encodings got mixed up between utf-8 and latin1.

thank you very much

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.