RE: Is storing a whack of text in a binary format ok?

2001-03-21 Thread Don Read 


On 21-Mar-01 WCBaker wrote:
 Hi,
 
 I can store and retrieve binary data in the form of image or sound files.
 However, I wanted to store up to say, 10,000 bytes of textual data.  Since
 varchar has a 255 byte ceiling I thought that mediumblob might be nice for
 this.   I can store the stuff as mediumblob without difficulty.
 
 However, when I try to retrieve the mediumblob (just character data
 originally) via PHP4, I tried this:
 
 $sectionText1=mysql_query(" select sectionText from sectionbinaries where
 TestID='$test' and section='$section' ");
 $section1=mysql_fetch_row($sectionText1);
 
 
 This section1 array gives me a raft of stuff, including a lot more than I
 want.   

No, it returns an array of one element $section1['sectionText'] (bad variable
naming, btw).

So I looked in the manual and found that:
"mysql_query() cannot be used for queries that contain binary data; you
 should use mysql_real_query() instead.  "
 
 
 SO I switched to:
 $sectionText1=mysql_real_query(" select sectionText from sectionbinaries
 where TestID='$test' and section='$section' ");
 $section1=mysql_fetch_row($sectionText1);
 
 and received the following error:
 Fatal error: Call to undefined function: mysql_real_query() in data.php3 on
 line 210
 
 
 Can anyone point me in the correct direction?
 
 1.  It is character data originally -- should I be using a mediumblob format
 to get 10,000 bytes or so into storage?

TEXT - `TEXT' column with a maximum length of 65535 (2^16 - 1)
 characters. 

 2.  What function might I use (and how can I use it) to correctly display
 the data if stored as something other than varchar?
 

don't confuse C (mysql_query  mysql_real_query) with PHP's mysql_query.

$res=mysql_query(" select sectionText from sectionbinaries where
   TestID='$test' and section='$section' ");
if ($res) {
  while ($row = mysql_fetch_object($res)) {
echo 'PText: ', $row-sectionText;
  }
  echo 'BR';
}


Regards,
-- 
Don Read [EMAIL PROTECTED]
-- If you are going to sin, sin against God, not the bureaucracy. 
  God will forgive you but the bureaucrats won't. 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Antwort: RE: Is storing a whack of text in a binary format ok?

2001-03-21 Thread alexander . skwar 


On 21.03.2001 10:14:34 Don Read wrote:

 So I looked in the manual and found that:
 "mysql_query() cannot be used for queries that contain binary data; you
  should use mysql_real_query() instead.  "

What manual?  MySQL manual?  If so, disregard that information - it's incorrect
as far as PHP is concerned, because:

  Fatal error: Call to undefined function: mysql_real_query() in data.php3 on
  line 210




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Is storing a whack of text in a binary format ok?

2001-03-20 Thread WCBaker 

Hi,

I can store and retrieve binary data in the form of image or sound files.
However, I wanted to store up to say, 10,000 bytes of textual data.  Since
varchar has a 255 byte ceiling I thought that mediumblob might be nice for
this.   I can store the stuff as mediumblob without difficulty.

However, when I try to retrieve the mediumblob (just character data
originally) via PHP4, I tried this:

$sectionText1=mysql_query(" select sectionText from sectionbinaries where
TestID='$test' and section='$section' ");
$section1=mysql_fetch_row($sectionText1);


This section1 array gives me a raft of stuff, including a lot more than I
want.   So I looked in the manual and found that:
   "mysql_query() cannot be used for queries that contain binary data; you
should use mysql_real_query() instead.  "


SO I switched to:
$sectionText1=mysql_real_query(" select sectionText from sectionbinaries
where TestID='$test' and section='$section' ");
$section1=mysql_fetch_row($sectionText1);

and received the following error:
Fatal error: Call to undefined function: mysql_real_query() in data.php3 on
line 210


Can anyone point me in the correct direction?

1.  It is character data originally -- should I be using a mediumblob format
to get 10,000 bytes or so into storage?
2.  What function might I use (and how can I use it) to correctly display
the data if stored as something other than varchar?

Thanks for your time!

-Warren






-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php