[prev in list] [next in list] [prev in thread] [next in thread] 

List:       solid
Subject:    Re: Your SOLID Download
From:       Mir S Islam <mislam () mindspring ! net>
Date:       1998-11-18 14:18:28
[Download RAW message or body]

Here is the script for those three tables. First table is fine. But next
tow tables whenever I try to insert large amount of text somehow it
turns into digits. I also tried to create a test table in the same
database with a binary field and tried to insert text. Same thing. Text
turned into digits. The only difference between first working table and
the other two tables are there is no key in second two tables. But that
should not matter. And I also created another test table with primary
key id and a binary column. That also resulted in the same thing.







CREATE TABLE feed_story ( 
  headline varchar(250)  NOT NULL,
  abstract binary,
  url varchar(250),
  pub_time varchar(10),
  pull_time varchar(10),
  feed_id varchar(22),
  feed_section_id varchar(40),
  enable varchar(1),
  PRIMARY KEY (headline)
);

CREATE TABLE zodiac (
  sign_id varchar(3),
  sign_name varchar(20),
  post_date varchar(10),
  prediction binary
);

CREATE TABLE of_the_day_feed (
  of_the_day_id varchar(12),
  post_date varchar(10),
  of_the_day_abstract binary
);




Iko Rein wrote:
> 
>         Hi,
> 
> > I think we are currently in process of obtaining licensed version for our
> > company Mindspring Enterprise. Meanwhile, I have a simple question. I have
> > a database with 30+ tables. Three of those tables have a binary field to
> > hold large amount of text. For two of the three tables, the binary field
> > works fine, but for the 2 and 3 table whenever something is inserted into
> > the binary column, it turns into some digits. I can't figure out why.
> >
> > I tried creating a brand new table with a binary field, and it was the
> > same ! I have not seen something like this before. ANy comments ?
>         Strange, could you send us bit more information
> about the creation scripts and insert scripts. That might
> help us. Please send a more detailed information about
> this behaviour to our support at evalsupp@solidtech.com,
> but you can also CC your questions to me, so I can
> follow up.
> 
>         Iko
> 
> --
> Mr. Iko  Rein,
> Solid Information Technology       Mobile +358 40 5519 358
> http://www.solidtech.com           Fax +358 9 4774 7390
> 
> SOLID is expanding - http://www.solidtech.com/company/opportun.htm

-- 
Mir S Islam
Software Engineer
Product Development
Mindspring Enterprise : MSPG
(404)815-0770 x2633

[prev in list] [next in list] [prev in thread] [next in thread]