Re: Postgres provider to use gda-srv lib

["Peter C. Norton" <spacey lenin nu>]

I'm worried about data corruption.  Let's say that data comes out, and it's
actually structured data of some kind.  It gets turned into a varchar, then
re-inserted into the database.  Because it was structured somehow (probably
with binary data) the locale settings could cause different data to be
re-inserted.

I'd like to float the idea of an undefined raw-data type for these cases,
where the user has to define some kind of translation for themselves.

-Peter

On Thu, Jul 06, 2000 at 12:12:29PM +0200, Vivien Malerba wrote:
> On jeu, 06 jui 2000, you wrote:
> > "Peter C. Norton" wrote:
> > > 
> > > I've started to re-write the db2 server to use the gda-mysql-server from
> > > cvs, too.
> > > 
> > Great!
> > 
> > > I agree on point 1, for case 2 can you provide a scenario where an unknown
> > > type can come back out of the database, and why a varchar2 would be the
> > > right datatype?  Are you thinking of a user-defined object? Dunno about 3
> > > yet.
> > > 
> > Well, an unknown data type coming from the database shouldn't happen,
> > but it CAN happen. Imagine for example the Oracle provider which is
> > compiled (the RPM) against oracle 8.0.5. In future Oracle releases,
> > there could be some new data types that the gda-oracle-srv is not aware
> > of. And, I think treating it as a varchar is the right thing for some
> > providers. For example, MySQL and PostgreSQL return data as strings, but
> > now that I think, it could not be the right solution for other
> > providers. What about the db2 server? how does it return data?
> > 
> 
> I thought about user defined data types, which for obvious reasons cannot be
> taken care of in gnome-db. I think returning a Varchar is the least bad think
> since Varchar is IMO the best way to describe something unknown (just put the
> contents between quotes).
> 
> Vivien
> 
> _______________________________________________
> gnome-db-list mailing list
> gnome-db-list@gnome.org
> http://mail.gnome.org/mailman/listinfo/gnome-db-list

-- 
The 5 year plan:
In five years we'll make up another plan.
Or just re-use this one.