| Author |
 Topic  |
|
|
joe8079
Posting Yak Master
USA
113 Posts |
 Posted - 05/04/2012 : 12:13:35
|
Hi, i'm not sure which forum to put this in, but when i'm trying to display a report in report manager, i'm getting the following error:
Somewhere in this table is a hexidecimal value but I cannot find it anywhere. Once I find it, i can filter this out. Does anyone know how to find this value in my table?
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.
There is an error in XML document (1, 379921).
'', hexadecimal value 0x18, is an invalid character. Line 1, position 379921.
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 05/04/2012 : 16:56:13
|
At position 379921 you have a character with ascii value 24 (hex 18).
Edit the file and remove the offending character.
N 56°04'39.26"
E 12°55'05.63" |
 |
|
|
joe8079
Posting Yak Master
USA
113 Posts |
Posted - 05/05/2012 : 00:08:15
|
Thanks for the response. This column in my database has over 452,000 rows. Is there a way I can find an ASCII value of 24? I was searching on google and all the suggestions are a while loop. I'm not sure if that would be a good idea with such a large production database on that many rows.
Here is the table: It has 450,000 rows
Example Below:
select StreetName from house_table
StreetName
Main Street
9th street
|
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 05/05/2012 : 03:25:54
|
This should only take a few seconds to under a minute...
SELECT * FROM dbo.House_Table
WHERE StreetName LIKE '%' + CHAR(24) + '%'
N 56°04'39.26"
E 12°55'05.63" |
|
|
|
joe8079
Posting Yak Master
USA
113 Posts |
Posted - 05/05/2012 : 14:33:59
|
| Thanks, I will try this on Monday. I couldn't find anything online that was helpful. So, this code will find any instance where the ascii value is 24 regardless of what position the value is in? |
|
|
|
joe8079
Posting Yak Master
USA
113 Posts |
Posted - 05/07/2012 : 11:14:54
|
SwePeso, thank you so much!
That worked. There were two records in that table out of 450,000 that had 24 as an ASCII Value. |
|
|
| |
Topic |
|
hexidecimal values
