Hi, User can also specify character set during the SELECT operation also with CHARACTER SET or charset.
Use mysql>charset utf 8 before issuing SELECT query. For Instance: If you do not say SET NAMES or SET CHARACTER SET, then for SELECT column1 FROM t, the server sends back all the values for column1 using the character set that the client specified when it connected, specified in the cnf file. On the other hand, if you say SET NAMES 'latin1' or SET CHARACTER SET latin1 before issuing the SELECT statement, the server converts the latin2 values to latin1 just before sending results back. Conversion may be lossy if there are characters that are not in both character sets. Ref: http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html Thanks ViSolve DB Team. ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Monday, October 09, 2006 2:23 PM Subject: Charset for SELECT ... INTO OUTFILE > Hi, > > I have a database where the database character set is utf-8 and some rows > are ascii. > > I want to save the results of some queries, and SELECT ... INTO OUTFILE > looks like an easy way to do it. But I need the output in ucs-2. Is there > any way to specify the charset for SELECT ... INTO OUTFILE, or is it always > uses the database character set? > > Thx. > > ImRe > > P.S.: Ver 5.0.24a-community-log > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
