distal-attribute
distal-attribute
distal-attribute
distal-attribute

HeidiSQL crashes when altering character set of table

User, date Message
Written by Wyzak
4 months ago
Category: General
3 posts since Thu, 03 Apr 14
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 : 8.3.0.4750
compiled with : Delphi XE5
madExcept version : 4.0.8.1
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

Written by ansgar
4 months ago
4936 posts since Fri, 07 Apr 06
This is due to the half ready bind parameters feature. Please refer to issue #1325, and post the callstack there as a comment.
Written by Wyzak
4 months ago
3 posts since Thu, 03 Apr 14
That is a very long post going back to 2009, could you point me to a specific post perhaps?
Written by ansgar
4 months ago
4936 posts since Fri, 07 Apr 06
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.
Written by Wyzak
4 months ago
3 posts since Thu, 03 Apr 14
Thanks for the help ansgar, I'll keep an eye on that topic.
 

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