Problem with cyrillic data in columns

[expired user #1609]'s profile image [expired user #1609] posted 17 years ago in General Permalink
I have a table with several VARCHAR columns, they are created with character set CP1251.
When I use the old MySQL Front Version 2.5.0.1 - it is OK, I can see and update values in these columns.
But when I use version 3.0RC3 and 3.0RC4, these columns are shown with asterisks (like that ????????).
What could be the reason for this ? Is it possible to set default character set for database connection (i.e. automatically issuing SET NAMES cp1251 at the start of connection) ?
Yes, I can run this SQL command by myself, but sometimes I forget it :)
ansgar's profile image ansgar posted 17 years ago Permalink

I have a table with several VARCHAR columns, they are created with character set CP1251.
When I use the old MySQL Front Version 2.5.0.1 - it is OK, I can see and update values in these columns.
But when I use version 3.0RC3 and 3.0RC4, these columns are shown with asterisks (like that ????????).
What could be the reason for this ?


In MySQL-Front 2.5 you had the option to use different charsets for data-editing in the preferences screen. I nuked this option because with the newer ZeosDbo version (the database layer) the character set cannot be set, not sure why.

Is it possible to set default character set for database connection (i.e. automatically issuing SET NAMES cp1251 at the start of connection) ?
Yes, I can run this SQL command by myself, but sometimes I forget it :)


This request is already posted and discussed here: http://sourceforge.net/tracker/?func=detail&atid=832350&aid=1605591&group_id=164593
[expired user #1609]'s profile image [expired user #1609] posted 17 years ago Permalink
Thanks, I read the specified discussion on SourceForge, let's see if this is going to be implemented in HeidiSQL :D

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