Re: incorrect string value

[Peter Brawley]

> can save and load this data into access or sql server

If you prefer to use database software which ignores such errors, it's up to you.

> data is fine, problem in something else.

The string excerpt in your error message elicits the same error message in the mysql client program ...

-- remove instances of the hex marker "\x" ... 
set @s = "A0A4@]0000";
select unhex(@s);
+-----------+
| unhex(@s) |
+-----------+
| NULL      |
+-----------+
1 row in set, 1 warning (0.00 sec)

Warning (Code 1411): Incorrect string value: '(@s)' for function unhex

Remove "]" from the string, and the error message goes away.



Edited 1 time(s). Last edit at 01/13/2021 12:39PM by Peter Brawley.