Re: insert a blob

2001-05-16 Thread Ilya Martynov
WA> thank you ! WA> i get it into the database but WA> with a select i get WA> select * from table; WA> [..skip..] WA> Can i read the data out and put in a file ? WA> you understand ? It probably just means that mysql client is confused by binary data. It usually doesn't handle it well. It do

Re: insert a blob

2001-05-16 Thread Ilya Martynov
WA> how can in insert i.e. a tar-archive in a blob ? WA> i want to do it with perl. i read allready about the quote function but i WA> wount work Try to use placholders. I'm under impression that quote is not reliable. At least man DBI says: Quote will probably not be able to deal wi

insert a blob

2001-05-16 Thread Weber Antonio
how can in insert i.e. a tar-archive in a blob ? i want to do it with perl. i read allready about the quote function but i wount work #!/usr/bin/perl use DBI; # DB-Vars $host = "ux4"; $database = "db_webera"; $user = "webera"; $pass = "webera"; $port = 3306; $driver = "mysql"; $dsn = "DBI:$dr