0

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.

2
Contributors
2
Replies
3
Views
6 Years
Discussion Span
Last Post by kvskchaitanya
1

Use the replace function:

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

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

Votes + Comments
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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.