Member Avatar for kvskchaitanya

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
  • 159 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by kvskchaitanya
Member Avatar for smantscheff

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
Member Avatar for kvskchaitanya

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.