Incorrect string value: '\\xD0\\xA2\\xD0\\x9E\\xD0\\x9E...' for column Username in MySQL DataGrip specific
0
votes
1
answer
745
views
I know that such error can be caused by incorrect character set applied to some table, but in my case it's a bit different:
I have some procedure with select, create temporary table and cursor...
The actual problem is that if I do
DROP/CREATE
procedure from JetBrain's DataGrip and CALL
it - error appears. But in case I do DROP/CREATE
of SAME procedure without any modification from other software, for example I've used DBForge - CALL
works just as expected! What can cause such behavior? I've used DataGrip for years now and this is the first time after which I start to worry about recreating procedures on production database.
Additional information: the error is caused by FETCH
of Username
column in cursor loop body. In case of commenting that part - everything works. So there is a problem FETCHING Username to my local variable DECLARE Username VARCHAR(300);
. Sizes of variables are same.
Asked by 0x49D1
(101 rep)
Oct 15, 2020, 11:19 AM
Last activity: Oct 15, 2020, 12:31 PM
Last activity: Oct 15, 2020, 12:31 PM