From: 赵琦 [mailto:tyzha...@gmail.com]
Sent: Thursday, April 21, 2011 9:19 PM
To: Jerry Schwartz
Cc: Johan De Meersman; sstap...@mnsi.net; mysql
Subject: Re: mysql deal with specail character problem
thanks for reply!
The charater set is latin1,and the key field is mangled by the email
tuxera.be]
> >Sent: Thursday, April 21, 2011 9:56 AM
> >To: sstap...@mnsi.net
> >Cc: ??; mysql; Jerry Schwartz
> >Subject: Re: mysql deal with specail character problem
> >
> >- Original Message -
> >> From: "Steve Staples"
> >&g
>-Original Message-
>From: Johan De Meersman [mailto:vegiv...@tuxera.be]
>Sent: Thursday, April 21, 2011 9:56 AM
>To: sstap...@mnsi.net
>Cc: ??; mysql; Jerry Schwartz
>Subject: Re: mysql deal with specail character problem
>
>- Original Message -
- 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
On Thu, 2011-04-21 at 09:35 -0400, Jerry Schwartz wrote:
> >-Original Message-
> >From: ?? [mailto:tyzha...@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;
>
é que les email peuvent facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
> From: je...@gii.co.jp
> To: tyzha...@gmail.com; mysql@lists.mysql.com
> Subject: RE: mysql deal with specail character problem
> Date: Thu,
>-Original Message-
>From: ?? [mailto:tyzha...@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)
- 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
stupid question: are you sure there was no previous entry in the table with
that value for a ?