Sample Header Ad - 728x90

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