List:General Discussion« Previous MessageNext Message »
From:Martin Gainty Date:April 21 2011 1:44pm
Subject:RE: mysql deal with specail character problem
View as plain text  
correct here is the output of INFORMATION_SCHEMA.COLUMNS

Create Table: CREATE TEMPORARY TABLE `COLUMNS` (
  `TABLE_CATALOG` varchar(512) DEFAULT NULL,
  `TABLE_SCHEMA` varchar(64) NOT NULL DEFAULT '',
  `TABLE_NAME` varchar(64) NOT NULL DEFAULT '',
  `COLUMN_NAME` varchar(64) NOT NULL DEFAULT '',
  `ORDINAL_POSITION` bigint(21) unsigned NOT NULL DEFAULT '0',
  `COLUMN_DEFAULT` longtext,
  `IS_NULLABLE` varchar(3) NOT NULL DEFAULT '',
  `DATA_TYPE` varchar(64) NOT NULL DEFAULT '',
  `CHARACTER_MAXIMUM_LENGTH` bigint(21) unsigned DEFAULT NULL,
  `CHARACTER_OCTET_LENGTH` bigint(21) unsigned DEFAULT NULL,
  `NUMERIC_PRECISION` bigint(21) unsigned DEFAULT NULL,
  `NUMERIC_SCALE` bigint(21) unsigned DEFAULT NULL,
  `CHARACTER_SET_NAME` varchar(64) DEFAULT NULL,
  `COLLATION_NAME` varchar(64) DEFAULT NULL,
  `COLUMN_TYPE` longtext NOT NULL,
  `COLUMN_KEY` varchar(3) NOT NULL DEFAULT '',
  `EXTRA` varchar(27) NOT NULL DEFAULT '',
  `PRIVILEGES` varchar(80) NOT NULL DEFAULT '',
  `COLUMN_COMMENT` varchar(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8

If i had configured utf16 or any character-set which supports DBCS then i *could*
implement CJK languages in the DB

how goes the recovery ?
Martin 
______________________________________________ 
Note de déni et de confidentialité
 Ce message est confidentiel et peut être privilégié. Si vous
n'êtes pas le destinataire prévu, nous te demandons avec bonté que
pour satisfaire informez l'expéditeur. N'importe quelle diffusion non
autorisée ou la copie de ceci est interdite. Ce message sert à
l'information seulement et n'aura pas n'importe quel effet légalement obligatoire.
Étant donné que les email peuvent facilement être sujets à la
manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu
fourni.




> From: jerry@stripped
> To: tyzhaoqi@stripped; mysql@stripped
> Subject: RE: mysql deal with specail character problem
> Date: Thu, 21 Apr 2011 09:35:02 -0400
> 
> >-----Original Message-----
> >From: ?? [mailto:tyzhaoqi@stripped]
> >Sent: Thursday, April 21, 2011 7:09 AM
> >To: mysql
> >Subject: mysql deal with specail character problem
> >
> >Hi:
> >I have a table that the field a is primary key;
> >I insert a record like this
> >insert into table(a,b,c) values('?????',1,1)
> >Then i insert a record like this
> > insert into table(a,b,c) values('?????',1,1)
> >
> >mysql post a error execute failed: Duplicate entry '?????-1-1' for key 1;
> >
> >it is strange, the primary key field is not the same, but i get this error.
> >
> >any one can help me?
> >
> [JS] What is the character set and collation for that field? Please post the 
> output of
> 
> SHOW CREATE TABLE x\G
> 
> (Please use the \G, so that the output will fit in your message better.)
> 
> There is something wrong with the way your data is going in, because the 
> commas are not being seen properly. You are putting in
> 
> '?????',1,1
> 
> but MySQL is showing
> 
> '?????-1-1'
> 
> in the error message! That is a clue.
> 
> I have put plenty of Japanese and Chinese characters into my database, so 
> don't give up hope.
> 
> >Thanks
> 
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 
 		 	   		  
Thread
mysql deal with specail character problem赵琦21 Apr
  • Re: mysql deal with specail character problemJohan De Meersman21 Apr
  • RE: mysql deal with specail character problemJerry Schwartz21 Apr
    • RE: mysql deal with specail character problemMartin Gainty21 Apr
    • RE: mysql deal with specail character problemSteve Staples21 Apr
      • Re: mysql deal with specail character problemJohan De Meersman21 Apr
        • RE: mysql deal with specail character problemJerry Schwartz21 Apr
          • Re: mysql deal with specail character problem赵琦22 Apr
            • RE: mysql deal with specail character problemJerry Schwartz25 Apr