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 client. [JS When you say that the character set is latin1, do you mean that the database is using latin1? That would definitely cause your problem, because the data would be truncated at the first character that isn’t latin1. Here’s a simple experiment: Add one row to your table, and then SELECT LENGTH() of your field. What comes back? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com <http://www.the-infoshop.com/> I up load the actual character of '?????' to the attachment. 2011/4/22 Jerry Schwartz <je...@gii.co.jp> >-----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> >> >> 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: je...@gii.co.jp Web site: www.the-infoshop.com <http://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