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

unicode/utf8 support

User, date Message
Written by Raigedas
7 years ago
Category: General
3 posts since Fri, 27 Apr 07
is there a unicode/utf8 support ?
Written by Pedja
7 years ago
6 posts since Wed, 01 Nov 06
Oh yes and it is very good. You just have to set table fields in proper codepage. HeidiSQL would allow you to edit them naturaly.
Written by Raigedas
7 years ago
3 posts since Fri, 27 Apr 07
what do you mean codepage? character set?

CREATE TABLE mytable (
myfieldchar(50) CHARACTER SET utf8
) ENGINE=MyISAM;

isn't this enough?


regards,
Raigedas
Written by Pedja
7 years ago
6 posts since Wed, 01 Nov 06
Yes, that is enough.

Make sure, that if you change table structure to set codepage, yu have to close connection to database and reconnect, to make HeidiSQL see change.
Written by Raigedas
7 years ago
3 posts since Fri, 27 Apr 07
yes, i have reopened HeidiSQL....

i have captured my screen to swf video, please look at it:
http://raigedas.info/utf8/

you see:
1. first i inserted english characters only,
2. then my own language characters that are set as default on my computer
3. and then i have inserted foreign characters, but they are turned into question marks after post.

what i may be doing wrong? : (

regards,
Raigedas
Written by rosenfield
7 years ago
127 posts since Wed, 24 Jan 07
HeidiSQL uses the ANSI version of various Windows components. This means that HeidiSQL can only use those UTF-8 characters that are present in your local Windows code page.

If you wish to use characters not in your local code page, you can switch your windows ANSI code page via the control panel and restart HeidiSQL.

Alternatively, if you have the time you can download the source code and convert HeidiSQL to use the WIDE version of Windows components. It should not be too hard to do using something like the TNT unicode components. They used to be free, but have recently been acquired and have had a price tag attached. Luckily there are derivatives that are still free, fx: http://mh-nexus.de/tntunicodecontrols.htm . The HeidiSQL developers are usually very helpful, if you should decide to throw some energy at the source code.
 

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