Hello,
Since it was released version 8, have a problem with displaying Serbian letters.
This problem did not exist in version 5th.
Here's a picture attached which shows how one looks in version 5 and one in the current version.
MySQL version is 4.1.22.
Thank you.
Problem with Serbian Latin letters
CREATE TABLE `account` (
`accountid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(150) NOT NULL DEFAULT '',
`code` VARCHAR(9) NOT NULL DEFAULT '',
`type` VARCHAR(255) NULL DEFAULT NULL,
`note` VARCHAR(255) NULL DEFAULT NULL,
`accountts` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`accountid`),
UNIQUE INDEX `code` (`code`),
INDEX `accountts` (`accountts`)
)
COLLATE='latin1_swedish_ci'
ENGINE=MyISAM
AUTO_INCREMENT=1465
;
Collation is "latin1_swedish".
At the time the database was created close to 2000 there was no other option and everything work perfectly.
But again Heidi version 5 all operate normally.
When I set a colation to latin2_croatian_ci, instead of Serbian letters I again receive various sings.
Picture is in Attach.
`accountid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(150) NOT NULL DEFAULT '',
`code` VARCHAR(9) NOT NULL DEFAULT '',
`type` VARCHAR(255) NULL DEFAULT NULL,
`note` VARCHAR(255) NULL DEFAULT NULL,
`accountts` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`accountid`),
UNIQUE INDEX `code` (`code`),
INDEX `accountts` (`accountts`)
)
COLLATE='latin1_swedish_ci'
ENGINE=MyISAM
AUTO_INCREMENT=1465
;
Collation is "latin1_swedish".
At the time the database was created close to 2000 there was no other option and everything work perfectly.
But again Heidi version 5 all operate normally.
When I set a colation to latin2_croatian_ci, instead of Serbian letters I again receive various sings.
Picture is in Attach.
Apparently, earlier HeidiSQL versions incorrectly displayed e.g. 0xC5BD bytes in a Latin-1 string as the Ž character (U+017E). To begin with, Latin-1 is a single byte encoding—that byte sequence should be interpreted as two characters: 0xC5 (Å aka U+00E5) and 0xBD (½ AKA U+00BD). Additionally, Latin-1 doesn't have most of those chars you mention.
Of course, this doesn't explain why you get � (U+FFFD) instead of Ž. But older behaviour was definitively a bug in HeidiSQL.
Of course, this doesn't explain why you get � (U+FFFD) instead of Ž. But older behaviour was definitively a bug in HeidiSQL.
Please login to leave a reply, or register at first.