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 赵琦
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

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 -

Re: mysql deal with specail character problem

2011-04-21 Thread Johan De Meersman
- 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

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; >

RE: mysql deal with specail character problem

2011-04-21 Thread Martin Gainty
é 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,

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)

Re: mysql deal with specail character problem

2011-04-21 Thread Johan De Meersman
- 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 ?