From: Martin Gainty
Date: April 21 2011 1:44pm
Subject: RE: mysql deal with specail character problem
List-Archive: http://lists.mysql.com/mysql/224839
Message-Id: <BLU142-W33B879F47012FF2F3FCBF8AE920@phx.gbl>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="_cbc4e693-7e7c-4683-a92b-a57962eba6ad_"

--_cbc4e693-7e7c-4683-a92b-a57962eba6ad_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


correct here is the output of INFORMATION_SCHEMA.COLUMNS

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

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=20
______________________________________________=20
Note de d=E9ni et de confidentialit=E9
 Ce message est confidentiel et peut =EAtre privil=E9gi=E9. Si vous n'=EAte=
s pas le destinataire pr=E9vu=2C nous te demandons avec bont=E9 que pour sa=
tisfaire informez l'exp=E9diteur. N'importe quelle diffusion non autoris=E9=
e ou la copie de ceci est interdite. Ce message sert =E0 l'information seul=
ement et n'aura pas n'importe quel effet l=E9galement obligatoire. =C9tant =
donn=E9 que les email peuvent facilement =EAtre sujets =E0 la manipulation=
=2C nous ne pouvons accepter aucune responsabilit=E9 pour le contenu fourni=
.




> From: jerry@stripped
> To: tyzhaoqi@stripped=3B mysql@stripped
> Subject: RE: mysql deal with specail character problem
> Date: Thu=2C 21 Apr 2011 09:35:02 -0400
>=20
> >-----Original Message-----
> >From: ?? [mailto:tyzhaoqi@stripped]
> >Sent: Thursday=2C April 21=2C 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=3B
> >I insert a record like this
> >insert into table(a=2Cb=2Cc) values('?????'=2C1=2C1)
> >Then i insert a record like this
> > insert into table(a=2Cb=2Cc) values('?????'=2C1=2C1)
> >
> >mysql post a error execute failed: Duplicate entry '?????-1-1' for key 1=
=3B
> >
> >it is strange=2C the primary key field is not the same=2C but i get this=
 error.
> >
> >any one can help me?
> >
> [JS] What is the character set and collation for that field? Please post =
the=20
> output of
>=20
> SHOW CREATE TABLE x\G
>=20
> (Please use the \G=2C so that the output will fit in your message better.=
)
>=20
> There is something wrong with the way your data is going in=2C because th=
e=20
> commas are not being seen properly. You are putting in
>=20
> '?????'=2C1=2C1
>=20
> but MySQL is showing
>=20
> '?????-1-1'
>=20
> in the error message! That is a clue.
>=20
> I have put plenty of Japanese and Chinese characters into my database=2C =
so=20
> don't give up hope.
>=20
> >Thanks
>=20
>=20
>=20
>=20
> --=20
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=3Dmgainty@stripped=
om
>=20
 		 	   		  =

--_cbc4e693-7e7c-4683-a92b-a57962eba6ad_--