-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Stormblade wrote:
> Thanks. I'd read that already but I re-read it and noticed this part here: > > "When a client connects, it sends to the server the name of the character > set that it wants to use. The server sets the character_set_client, > character_set_results, and character_set_connection variables to that > character set. (In effect, the server performs a SET NAMES operation using > the character set.)" > > So basically on the client end when I make a connection I need to tell it > to use a character set. I'll have to check my documentation. I'm connecting > via JDBC so I'm guessing it must be part of the connection string. Stormblade, If you're using UTF-8 data and JDBC, and you _haven't_ set the _server_ charset to UTF-8, you'll need to add 'characterEncoding=UTF-8' as a property to your JDBC connection string. You'll also probably want to use the latest nightly snapshot of either Connector/J 3.0 or 3.1 as they have code to support the behavior of Unicode charsets in MySQL-4.1.2. See http://downloads.mysql.com/snapshots.php for more information. -Mark - -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 332 0507 www.mysql.com Meet the MySQL Team! April 14-16, 2004 http://www.mysql.com/uc2004/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD4DBQFAhpS0tvXNTca6JD8RAlc7AKCRIHqxyro+5lc721Q4rrPhGwnElQCVGvtL OQlzSKgNZfr5xema2CA5vA== =Pt0L -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
