mysql deal with specail character problem

--20cf307f38becd378b04a16bc46a
Content-Type: text/plain; charset=GB2312
Content-Transfer-Encoding: quoted-printable

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 '¼Ã¹«È«=B4=
«¢=DA-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?

Thanks

--20cf307f38becd378b04a16bc46a--

Re: mysql deal with specail character problem

----- Original Message -----
> From: "赵琦"
>
> it is strange, the primary key field is not the same, but i get this
> error.

I'm entirely unsure how MySQL handles non-roman, so I'll start off with a s=
tupid question: are you sure there was no previous entry in the table with =
that value for a ?


--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

RE: mysql deal with specail character problem

>-----Original Message-----
>From: ?? [mailto:tyzhaoqi@gmail.com]
>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=gcdmg-mysql-2@m.gmane.org

RE: mysql deal with specail character problem

--_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@gii.co.jp
> To: tyzhaoqi@gmail.com=3B mysql@lists.mysql.com
> Subject: RE: mysql deal with specail character problem
> Date: Thu=2C 21 Apr 2011 09:35:02 -0400
>=20
> >-----Original Message-----
> >From: ?? [mailto:tyzhaoqi@gmail.com]
> >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@hotmail.c=
om
>=20
=

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

RE: mysql deal with specail character problem

On Thu, 2011-04-21 at 09:35 -0400, Jerry Schwartz wrote:
> >-----Original Message-----
> >From: ?? [mailto:tyzhaoqi@gmail.com]
> >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

Doesn't the '?????-1-1' mean that it's a joined key? so the 3 fields
he's inserting, are part of a multi-field key... but to me, it looks
like the characters are not being seen, or converted to a UTF-8 style
format, rather than the chinese (korean/japanese) character set.. ?
maybe?

sorry if i am out of line here...

Steve.




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: mysql deal with specail character problem

----- Original Message -----
> From: "Steve Staples"
>
> Doesn't the '?????-1-1' mean that it's a joined key? so the 3

That's what I tought, but I *can* see the characters he's typed, and the last of what you see as ? is definitely different.


--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: mysql deal with specail character problem

>-----Original Message-----
>From: Johan De Meersman [mailto:vegivamp@tuxera.be]
>Sent: Thursday, April 21, 2011 9:56 AM
>To: sstaples@mnsi.net
>Cc: ??; mysql; Jerry Schwartz
>Subject: Re: mysql deal with specail character problem
>
>----- Original Message -----
>> From: "Steve Staples"
>>
>> Doesn't the '?????-1-1' mean that it's a joined key? so the 3
>
>That's what I tought, but I *can* see the characters he's typed, and the last
>of what you see as ? is definitely different.
>
[JS] That's because his font (or e-mail client) mangled the text, and so his
reply wasn't legible.

Our main office is in Japan, so I go through this all the time.


Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341
E-mail: jerry@gii.co.jp
Web site: www.the-infoshop.com
>
>--
>Bier met grenadyn
>Is als mosterd by den wyn
>Sy die't drinkt, is eene kwezel
>Hy die't drinkt, is ras een ezel




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: mysql deal with specail character problem

--000e0cd573dc75759f04a177a5e8
Content-Type: multipart/alternative; boundary=000e0cd573dc75759304a177a5e6

--000e0cd573dc75759304a177a5e6
Content-Type: text/plain; charset=ISO-8859-1

thanks for reply!

The charater set is latin1,and the key field is mangled by the email client.

I up load the actual character of '?????' to the attachment.

2011/4/22 Jerry Schwartz

>
>
> >-----Original Message-----
> >From: Johan De Meersman [mailto:vegivamp@tuxera.be]
> >Sent: Thursday, April 21, 2011 9:56 AM
> >To: sstaples@mnsi.net
> >Cc: ??; mysql; Jerry Schwartz
> >Subject: Re: mysql deal with specail character problem
> >
> >----- Original Message -----
> >> From: "Steve Staples"
> >>
> >> Doesn't the '?????-1-1' mean that it's a joined key? so the 3
> >
> >That's what I tought, but I *can* see the characters he's typed, and the
> last
> >of what you see as ? is definitely different.
> >
> [JS] That's because his font (or e-mail client) mangled the text, and so
> his
> reply wasn't legible.
>
> Our main office is in Japan, so I go through this all the time.
>
>
> Regards,
>
> Jerry Schwartz
> Global Information Incorporated
> 195 Farmington Ave.
> Farmington, CT 06032
>
> 860.674.8796 / FAX: 860.674.8341
> E-mail: jerry@gii.co.jp
> Web site: www.the-infoshop.com
> >
> >--
> >Bier met grenadyn
> >Is als mosterd by den wyn
> >Sy die't drinkt, is eene kwezel
> >Hy die't drinkt, is ras een ezel
>
>
>
>

--000e0cd573dc75759304a177a5e6
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable