HeidiSQL crashes when altering character set of table

Wyzak posted 2 years ago in General
Hi there,

I'm trying to change the character set of my tables from the default latin1 to utf8_general. I've managed to set the default on the table, and then when I call the query below to actually convert the table contents I get a crash.

the query: alter table misc_hw_info convert to character set utf8 collate utf8_general_ci;

the result: 246 rows affected, and then:

date/time : 2014-04-03, 14:41:32, 334ms
computer name : SERVERPCNAME
wts client name : CLIENTPC
user name : adminname <admin>
registered owner : Ownername
operating system : Windows Vista Service Pack 2 build 6002
system language : English
system up time : 1 day 6 hours
program up time : 54 seconds
processors : 4x Intel(R) Core(TM) i7-3770K CPU @ 3.50GHz
physical memory : 2836/3967 MB (free/total)
free disk space : (C:) 18.72 GB
display mode : 1024x768, 32 bit
process id : $ef0
allocated memory : 44.91 MB
largest free block : 1.17 GB
executable : heidisql.exe
exec. date/time : 2014-04-02 06:45
version :
compiled with : Delphi XE5
madExcept version :
callstack crc : $df33f7bd, $b64a2593, $b64a2593
exception number : 1
exception class : EAccessViolation
exception message : Access violation at address 006B9C48 in module 'heidisql.exe'. Read of address 000002C8.

main thread ($c70):
006b9c48 heidisql.exe SynEdit 1878 +1 TCustomSynEdit.SynGetText
0093fc68 heidisql.exe Main 5649 +10 TMainForm.TimerBindParamsTimer
006211d7 heidisql.exe Vcl.ExtCtrls TTimer.Timer
006210bb heidisql.exe Vcl.ExtCtrls TTimer.WndProc
0053b600 heidisql.exe System.Classes StdWndProc
76830226 USER32.dll DispatchMessageW
0068510b heidisql.exe Vcl.Forms TApplication.ProcessMessage
0068514e heidisql.exe Vcl.Forms TApplication.HandleMessage
00685489 heidisql.exe Vcl.Forms TApplication.Run
00969993 heidisql.exe heidisql 77 +24 initialization
768fd2e7 kernel32.dll BaseThreadInitThunk

ansgar posted 2 years ago
This is due to the half ready bind parameters feature. Please refer to issue #1325, and post the callstack there as a comment.
Wyzak posted 2 years ago
That is a very long post going back to 2009, could you point me to a specific post perhaps?
ansgar posted 2 years ago
The last 5 or 7 comments are relevant only. I guess you don't need to post anything, but you could starr the issue, so you get a notification whenever there is activity on that issue.
Wyzak posted 2 years ago
Thanks for the help ansgar, I'll keep an eye on that topic.

Please login to leave a reply, or register at first.