Re: Reg Text field data

2005-02-25 Thread Gleb Paharenko
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]



Reg Text field data

2005-02-24 Thread lakshmi.narasimharao

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
 




[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]
 


--
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]




Confidentiality Notice

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.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]