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:vegiv...@tuxera.be]
> >Sent: Thursday, Apri
>-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 -
>> From: "Steve Staples"
>>
>> Do
- 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;
>
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 '',
>-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 ?
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