Re: how to use convert_uuencode()

From: Andy Hassall (andy_at_andyh.co.uk)
Date: 09/30/04 

Date: Thu, 30 Sep 2004 20:02:46 +0100

On 30 Sep 2004 09:15:29 -0700, lkrubner@geocities.com (lawrence) wrote:

>On www.php.net, on the page for convert_uuencode(), someone posted
>this comment:
>
>>>>>>>>>>>>>>>>>
>This function can be useful if you wish to store files in a MySQL
>database, it will save any problems with obscure binary data breaking
>the queries.
>
>just remember to convery-uudecode before you try to use the data
>again.
>
>(A common example of something that uses this system, would be email
>attachments)
>>>>>>>>>>>>>>>>>
>
>If I understand this right, before you insert any binary data into a
>MySql database, you should first hit it with convert_uuencode() ?

 No, MySQL is perfectly capable of storing binary data without needing
encoding, using the BLOB types. uuencoding it adds overhead in both processing
time and space required. 

-- 
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool

Relevant Pages

  • how to use convert_uuencode()
    ... This function can be useful if you wish to store files in a MySQL ... it will save any problems with obscure binary data breaking ... MySql database, you should first hit it with convert_uuencode? ...
    (comp.lang.php)
  • Re: how to use convert_uuencode()
    ... >> This function can be useful if you wish to store files in a MySQL ... it will save any problems with obscure binary data breaking ... MySql, Postgre, or an XML flat file. ... stored in the text fields of any database. ...
    (comp.lang.php)
  • Re: C client to load binary data to MySQL
    ... using, programming, and administering MySQL" by Paul DuBois. ... unsigned int from_len; ... large this expression already points outside of 'query'. ... mysql_querycannot be used for queries that contain binary data; ...
    (comp.lang.c)
  • Re: PostgreSQL
    ... PosgreSQL does some things a lot better tha MySQL does, ... into "chunks" and stores the chunks in tuples in the database. ... My own benchmarks show MySQL and SQLite handle binary data much ...
    (Fedora)
  • Re: MySQL Database problem (probably already solved in a message, but this is somewhat urgent)
    ... MySQL server has a database with a table, ... columns, an FSR column, and a password column. ... checked if the supposed arrays that were returned were actually arrays ...
    (comp.lang.php)