MySQL Forums
Forum List  »  Connector/ODBC

Re: incorrect string value
Posted by: Peter Brawley
Date: January 13, 2021 11:45AM

> 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.

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.