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]