From: Warren Young
Date: October 20 2006 10:26am
Subject: Re: Connection character set be changed silently?
List-Archive: http://lists.mysql.com/plusplus/6054
Message-Id: <4538A44F.7030601@etr-usa.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hanson Lu wrote:
> why the characoter set would be changed  with MYSQL 4.1.12?

Because the character set is a connection attribute.  When the 
connection was re-established, the character set returned to its default.

> My programm use MYSQL C API.

Then please use the main MySQL list for this sort of thing in the 
future.  This list is only for MySQL++, the C++ wrapper for the C API.