About character_set_*

2012-08-07 Thread Zhigang Zhang
Hello. As I know, when client send data to server, the encoding converting process is: character_set_client --> character_set_connection --> db table encoding. I think it is a short path than above way: character_set_client --> db table encoding. Why it is converted to "char

RE: trouble with perl

2012-08-07 Thread Stillman, Benjamin
http://bixsolutions.net/forum/thread-18.html -Original Message- From: Elim Qiu [mailto:elim@gmail.com] Sent: Monday, August 06, 2012 5:42 PM To: mysql@lists.mysql.com Subject: trouble with perl To populate table for a perl forum, I got the following error: aMac:mwf elim$ perl instal

Re: trouble with perl

2012-08-07 Thread Elim Qiu
Thanks Stillman Benjamin. The link is about the mismatch of 32/64 bit among mysql, perl and os processor but I don't have that issues. My system is missing DBD::mysql module, and I still have trouble with that. On Tue, Aug 7, 2012 at 6:49 AM, Stillman, Benjamin < bstill...@limitedbrands.com> wro

MySQL Connector/Python 1.0.5 beta has been released

2012-08-07 Thread Kent Boortz
Dear MySQL users, MySQL Connector/Python v1.0.5 is a new version of the pure Python database driver for MySQL. This is the first in a series of beta releases that will introduce users to new features and changes. This release is feature complete, but as a non-GA release is not recommended for us

MySQL Community Server 5.6.6 has been released

2012-08-07 Thread Joerg Bruehe
Dear MySQL users, MySQL Server 5.6.6 (Milestone Release) is a new version of the world's most popular open source database. The new features in these releases are of beta quality. As with any other pre-production release, caution should be taken when installing on production level systems or sys

RE: About character_set_*

2012-08-07 Thread Rick James
The answer is long and involved... http://mysql.rjweb.org/doc.php/charcoll > -Original Message- > From: Zhigang Zhang [mailto:zzgang2...@gmail.com] > Sent: Tuesday, August 07, 2012 3:25 AM > To: mysql@lists.mysql.com > Subject: About character_set_* > > Hello. > > > > As I know, when

Re: query help

2012-08-07 Thread hsv
2012/07/31 15:02 -0700, Haluk Karamete So, in a case like this shop.orders.32442 shop.orders.82000 shop.orders.34442 It would be the record whose source_recid is shop.orders.82000. Why? Cause 82000 happens to be the largest integer. Now, if they are always 5-digit-long integer

Re: DECIMAL datatype automatically makes blank become 0

2012-08-07 Thread hsv
2012/08/04 23:14 -0400, Fred G I'm using MySQL 5.2 Workbench, and when I import a csv into MySQL, blank values become 0 when I define the datatype to be a DECIMAL (in our case (DECIMAL(12,2)). Since there is the potential for values to be 0, this poses a problem for us. I initially wanted

RE: About character_set_*

2012-08-07 Thread Martin Gainty
Unless your effort is to convert all text strings to Mainland Chinese only ...Dont forget 'Locale' http://dev.mysql.com/doc/refman/5.5/en/locale-support.html Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité D

Re: trouble with perl

2012-08-07 Thread Perrin Harkins
Hi, This probably means you changed your MySQL libraries but didn't recompile or reinstall DBD::mysql, Usually this kind of issue is solved by reinstalling DBD::mysql in the same way that you previously installed it, so it can build against your current libraries. - Perrin On Mon, Aug 6, 2012 a

Error starting data node

2012-08-07 Thread Aastha
Helo, I am receiving error when trying to start the data node. The configuration seems ok. Kindly help. *C:\mysql\bin>ndbd* *Unable to connect with connect string: nodeid=10,172.17.3.66:1186* *Retrying every 5 seconds. Attempts left: 12 11 10 9 8 7 6 5 4 3 2 1, failed.* *2012-08-07 18:19:20 [ndbd

UDF writing to unix socket - segfaults?

2012-08-07 Thread Per Jessen
I am writing a UDF for sending messages to a local daemon. I've been trying to make it use a UNIX socket, but it keeps segfaulting on connect() or sendto(). I have double and tripled checked everything, but I'm not finding anything. After a day or two, I finally decided to switch to UDP and writ