tags:

views:

265

answers:

3
+1  Q: 

char '0x8' what character is this?

I have a large amount of data in a database. When I attempt to read a certain portion of the data and generate some xml and send it to a webservice I get the following exception...

The char '0x8' in 'java.lang.IllegalArgumentException'.

I'm guessing it is some bad data, as it has worked perfectly for about 7 months but now some user uploaded some new data that seems to have some issues.

Anyone know what character this is so I can just run a sql query and clean it from the db? Thanks in advance.

+5  A: 

8 is usually a backspace.

No Refunds No Returns  2010-03-01 19:38:58
It's also CTRL-H, BTW.
Laurence Gonsalves  2010-03-01 19:48:48
+7  A: 

The ASCII Character 0x08 (or 8) would be the Backspace character.ASCII Map

NebuSoft  2010-03-01 19:40:35
+1 for pointing out that the meaning of 0x08 depends on the charset.
Malax  2010-03-01 19:43:25
A: 

You can convert into Binary Base64 while storing data into XML to solve these issues.

Surya  2010-05-07 17:05:36

related questions

inserting hex value into mysql
Send binary to the serial port
Output ASCII Value C++
Check if Char is in range
Comparing Char which holds hex values C++
Why use hex?
How can I Convert a Big decimal number to Hex in C# (Eg : 588063595292424954445828)
Converting a paragraph to hex notatation, then back to string
Converting a String to HEX in SQL
Converting hex to RGB and vice-versa
Convert hex string to int in Python
How can I unpack binary hex formatted data in Python?
Binary Database Aligned or Packed
Any Generic Utilities or Libraries for Converting Hex Dumps into Human-readable Form?
Hex operations in C#
vb.net - sending UDP data including hex
Can someone explain hex offsets to me?
Passing timestamp parameters in SQLAnalyzer to debug stored procedures
Callstack that has has AV reported I see FunctionName() + some Hex value?
char[] to hex string exercise
How to convert decimal to hex in JavaScript?
Where did these hex named folders come from?
Off-the-Shelf C++ Hex Dump Code
What is a good Windows hex editor / viewer?
Decoding T-SQL CAST in C#/VB.net