RE: mysql deal with specail character problem

2011-04-25 Thread Jerry Schwartz
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

Re: mysql deal with specail character problem

2011-04-21 Thread Johan De Meersman
- Original Message - From: 赵琦 tyzha...@gmail.com 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

RE: mysql deal with specail character problem

2011-04-21 Thread Jerry Schwartz
-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) Then i

RE: mysql deal with specail character problem

2011-04-21 Thread Martin Gainty
fourni. From: je...@gii.co.jp To: tyzha...@gmail.com; mysql@lists.mysql.com Subject: RE: mysql deal with specail character problem Date: Thu, 21 Apr 2011 09:35:02 -0400 -Original Message- From: ?? [mailto:tyzha...@gmail.com] Sent: Thursday, April 21, 2011 7:09 AM To: mysql

RE: mysql deal with specail character problem

2011-04-21 Thread Steve Staples
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; I insert a

Re: mysql deal with specail character problem

2011-04-21 Thread Johan De Meersman
- Original Message - From: Steve Staples sstap...@mnsi.net 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

RE: mysql deal with specail character problem

2011-04-21 Thread Jerry Schwartz
-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 sstap...@mnsi.net

Re: mysql deal with specail character problem

2011-04-21 Thread 赵琦
: 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 sstap...@mnsi.net Doesn't the '?-1-1' mean that it's a joined key? so the 3 That's what I tought