weird character in DB resultset

tags:

views:

33

answers:

2

Q:

weird character in DB resultset

So I'm running a query against my database and looping through the results and getting something like-

F.�B.�Webster�Day�

in most of the results. Those should be spaces but it must've been something weird during the import/conversion (damn you M$).

Is there a quick query I can run against the DB to remove all of those and replace them with spaces?

+1 A:

it should be a different collaption from the two databases... try to change the db collaption as the old...

Marcx 2010-03-05 01:05:20

s/collaption/collation/

DaveE 2010-03-05 01:45:51

+1 A:

IS there anyway you can get a HEX dump of the output?

From the looks of it these characters probably started life as the NBSP (non breaking space character) x'A0', but they may have been mistranslated to something else.

If it is you can easily fix this using the REPLACE() function in an update statement.

James Anderson 2010-03-05 01:43:57

The replace worked great. What I did was just go into the database using SQLyog (but I guess any other DB manager would work) and copy/pasted the weird space " " and then did a replace with a normal space " " and ran this query: `UPDATE attorneys SET ``name``=REPLACE(``name``," "," ")` worked like a charm, thanks!

Marty 2010-03-05 14:38:44

The table named 'name' should have the tick quotes around them but here it interprets them as code markup and isn't showing them. Just for future posterity and anyone who finds this post w/ a similar question.

Marty 2010-03-05 14:40:53

ansaurus

tags:

views:

answers:

weird character in DB resultset

related questions