Hello.
What client do you use? You may use -e option for mysql client program and store result in the file: mysql -e 'select * from test.table' > res.txt 'SELECT ... INTO OUTFILE' may be useful. [EMAIL PROTECTED] wrote: > > Hi, > How to read a text type field from the data base. By simple > select I am not able to see the whole data at a time. Please advise me > here. > > > Thanks, > Narasimha > > -----Original Message----- > From: Gleb Paharenko [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 23, 2005 9:06 PM > To: mysql@lists.mysql.com > Subject: Re: Change default character_set_client, connection, results > > Hello. > > Use MYSQL_SET_CHARSET_NAME option for mysql_options() function. See: > > http://dev.mysql.com/doc/mysql/en/mysql-options.html > =0D > > > > > [snip] > > Hello, > > could someone tell me if it is possible to change default settings for > character_set_client, character_set_connection and > character_set_results variables? They > are always set to latin1 and I didn't find any way how to change their > default value. > I'm using MySQL 4.1.9-nt and MySQL ODBC 3.51. My applications are > written in C++ Builder > and I don't want to send command SET NAMES 'cp1250' whenever > application opens > connection. > > Thanks in advance > > [snip] > =0D > > > --=0D > For technical support contracts, goto > https://order.mysql.com/?ref=3Densita > This email is sponsored by Ensita.NET http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET > <___/ www.mysql.com > > > > > --=0D > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > Confidentiality Notice=0D > > The information contained in this electronic message and any attachments to= > this message are intended > for the exclusive use of the addressee(s) and may contain confidential or= > privileged information. If > you are not the intended recipient, please notify the sender at Wipro or= > [EMAIL PROTECTED] immediately > and destroy all copies of this message and any attachments. > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
