Hello mysql, I setup server (my.ini/my.cnf) with default-character-set = koi8_ru
Than do 'myisamchk -r -q' It seems to use correct charset. i do: 1.it's ok: INSERT INTO allg (znum_allg,name) VALUES (20,"À") 2.it's error with INSERT INTO allg (znum_allg,name) VALUES (20,"Á") error: Duplicate entry 'À' for key 2 bug is presented on 3.23.37 (linux) and 3.23.51 (windows) throu webpage submit and direct insert. Table definition: CREATE TABLE `allg` ( `znum_allg` int(11) NOT NULL default '0', `name` char(100) NOT NULL default '', `name_lc` char(100) default NULL, `namealt` char(100) default NULL, `url` char(200) default NULL, `verlag` char(100) default NULL, `sortname` char(40) default NULL, `gedr_ausg` char(1) default NULL, `elek_ausg` char(1) default NULL, `allg_bem` char(200) default NULL, `elekfrei_falle` char(1) default NULL, `elekfrei_drabo` char(1) default NULL, `elek_gebuer` char(1) default NULL, `elek_billig` char(1) default NULL, `elek_bemerk` char(200) default NULL, `ipzugang` char(1) default NULL, `pwzugang` char(1) default NULL, `regzugang` char(1) default NULL, `subszugang` char(1) default NULL, `issn_d` char(30) default NULL, `issn_e` char(30) default NULL, `ppn_d` char(20) default NULL, `ppn_e` char(20) default NULL, `zdb_d` char(20) default NULL, `zdb_e` char(20) default NULL, `zeta` char(30) default NULL, `bk` char(30) default NULL, `epn` char(30) default NULL, `joker1` char(1) default NULL, `joker2` char(1) default NULL, `joker3` char(1) default NULL, `joker4` char(1) default NULL, `joker5` char(1) default NULL, `joker6` char(1) default NULL, `joker7` char(1) default NULL, `joker8` char(1) default NULL, `joker9` char(1) default NULL, `joker10` char(10) default NULL, `joker11` char(20) default NULL, `joker12` char(20) default NULL, `odate` char(20) default NULL, `opers` char(40) default NULL, `oort` char(10) default NULL, `lmort` char(10) default NULL, `lmpers` char(40) default NULL, `lmdate` char(20) default NULL, UNIQUE KEY `idxnum` (`znum_allg`), UNIQUE KEY `idxzname` (`name`) ) TYPE=MyISAM -- Best regards, Andrew mailto:ashvedov@;tut.by --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
