List:General Discussion« Previous MessageNext Message »
From:Danny Terweij Date:November 3 2004 9:43am
Subject:Re: How to read TINYBLOB fields from the database
View as plain text  
From: "Gleb Paharenko" <gleb.paharenko@stripped>

> Send us versions of software you use, and output of

The MySQL server is hosted on a windows machine.
No remote access to that. just an read only account to the database.

>   show create table 'table'.

                                                           Table
Create Table  users
CREATE TABLE `users` (
  `name` varchar(65) binary default NULL,
  `a` varchar(129) NOT NULL default '',
  `b` varchar(255) NOT NULL default '',
  `c` varchar(255) NOT NULL default '',
  `d` varchar(33) NOT NULL default '',
  `e` tinyblob NOT NULL,
  `f` tinyblob NOT NULL,
  `g` tinyblob NOT NULL,
  `h` tinyblob NOT NULL,
  `i` tinyblob NOT NULL,
  `j` tinyblob NOT NULL,
  `k` tinyblob NOT NULL,
  `l` tinyblob NOT NULL,
  `m` tinyblob NOT NULL,
  `n` tinyblob NOT NULL,
  `o` tinyblob NOT NULL,
  `p` tinyblob NOT NULL,
  `locked` tinyint(3) unsigned NOT NULL default '0',
  `extra` varchar(65) binary default NULL,
  `time` timestamp(14) NOT NULL,
  KEY `name` (`name`)
) TYPE=MyISAM


> Can you read non-blob field from this table (or others)?

yes the non-blob fields works just fine
And if i do the same way on blob fields i see just garbage like
"&*(^yuhg789"  But i know that fields holds a number or word.
So i think its something to do with converting binary-format to ?.

Danny Terweij.




Thread
How to read TINYBLOB fields from the databaseDanny Terweij2 Nov
  • Re: How to read TINYBLOB fields from the databaseGleb Paharenko3 Nov
  • Re: How to read TINYBLOB fields from the databaseDanny Terweij3 Nov
    • Re: How to read TINYBLOB fields from the databaseGleb Paharenko5 Nov