MySQL Forums :: Character Sets, Collation, Unicode :: Command line UTF8 encoding

Advanced Search

Re: Command line UTF8 encoding
Posted by: Barry Galbraith ()
Date: May 28, 2010 06:23PM

I found this in the Refman here


Character set issues affect not only data storage, but also communication between client programs and the MySQL server. If you want the client program to communicate with the server using a character set different from the default, you'll need to indicate which one. For example, to use the utf8 Unicode character set, issue this statement after connecting to the server:

SET NAMES 'utf8';

For more information about configuring character sets for application use and character set-related issues in client/server communication, see Section 9.1.5, “Configuring the Character Set and Collation for Applications”, and Section 9.1.4, “Connection Character Sets and Collations”.

Good luck,

Options: ReplyQuote

Subject Views Written By Posted
Command line UTF8 encoding 16314 Gabriel Llamas 05/28/2010 06:37AM
Re: Command line UTF8 encoding 7851 Barry Galbraith 05/28/2010 06:23PM
Re: Command line UTF8 encoding 4972 Gabriel Llamas 05/29/2010 01:05AM
Re: Command line UTF8 encoding 4394 Barry Galbraith 05/29/2010 01:40AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.