[SqueakDBX] MSSQL, selecting nvarchar (other types too) field
causes DBXTypeNotSupported.
Mikey.Sanchez at gmail.com
Mikey.Sanchez at gmail.com
Thu May 5 14:03:54 UTC 2011
Your read my mind. I was just firing up the debugger to have a look at the
whole thing.
However I've just had a call from my babysitters and I have to go home and
take my daughter to the pediatrician. I'll start tomorrow.
Miguel
On May 5, 2011 3:57pm, Mariano Martinez Peck <marianopeck at gmail.com> wrote:
> So...Miguel, we really want to fix this. Let's think together ;)
> The "unsupported" right now are:
> at: 16r20 put: (DBXTypeNotSupported type: #CLOB);
> at: 16r21 put: (DBXTypeNotSupported type: #NCLOB);
> at: 16r22 put: (DBXTypeNotSupported type: #XML);
> at: 16r2F put: (DBXTypeNotSupported type: #BLOB);
> at: 16r35 put: (DBXTypeNotSupported type: #INTERVAL);
> at: 16r40 put: (DBXTypeNotSupported type: #ARRAY);
> at: 16r41 put: (DBXTypeNotSupported type: #MULTISET);
> at: 16r50 put: (DBXTypeNotSupported type: #DATALINK);
> at: 16rFF put: (DBXTypeNotSupported type: #UNKNOWN);
> Now...the thing os how to convert them from string to Pharo objects, and
> vice-versa. That is, implementing #fromDbxString: aString and #asDbxString
> So...to which classes should be map ?
> Clob -> String?
> NClob -> WideString ?
> XML -> String ?
> Blob -> ByteArray ?
> I think that with these 4 we cover 90% of the needs ;)
> Interval -> Interval ?
> Array -> Array ?
> MultiSet -> Bag ?
> DataLink -> no idea
> opinions ???
> On Fri, Apr 29, 2011 at 5:09 PM, Mariano Martinez Peck
> marianopeck at gmail.com> wrote:
> On Fri, Apr 29, 2011 at 5:05 PM, Miguel Sanchez mikey.sanchez at gmail.com>
> wrote:
> Hey Mariano,
> Thanks for the link. Actually nvarchar *is* there. National Character
> Varying. It says it maps to Character Varying (varchar). I'll keep
> looking
> heheheheh sorry. I was in a hurry so I did a simplt cmd + f in the page ;)
> Thanks for letting me know.
> BTW, you can also check:
> http://www.squeakdbx.org/Mappings%20from%20String%20to%20specific%20squeak%20types%20in%20selects
> Cheers
> mariano
> Miguel
> On 29 April 2011 16:14, Mariano Martinez Peck marianopeck at gmail.com>
> wrote:
> >
> >
> > On Fri, Apr 29, 2011 at 3:53 PM, Miguel Sanchez mikey.sanchez at gmail.com>
> > wrote:
> >>
> >> OK thanks guys I'll answer answer both in one shot.
> >>
> >> > Date: Fri, 29 Apr 2011 10:54:37 +0200
> >> > From: Mariano Martinez Peck marianopeck at gmail.com>
> >> > Subject: Re: [SqueakDBX] MSSQL, selecting nvarchar (other types too)
> >> > field causes DBXTypeNotSupported.
> >> > To: The complete and open-source solution to relational database
> >> > access squeakdbx at lists.squeakfoundation.org>
> >> > Message-ID: WbRtfRVxw at mail.gmail.com>
> >> > Content-Type: text/plain; charset="iso-8859-1"
> >> >
> >> > Hi Miguel. This is something that we really need to fix and make it
> >> > clear.
> >>
> >> My apologies for the newbie questions and generally being dense about
> >> understanding the code.
> >>
> >
> > your questions are very welcome.
> >
> >>
> >> >
> >> > I will try to explain: OpenDBX library have 4 special functions
> (check
> >> > above in http://www.linuxnetworks.de/doc/index.php/OpenDBX/C_API/1.2)
> >> > when
> >> > managing large objects WHEN the backend requires such.
> >> > We wrongly understood that at the beginning. So...we throw
> >> > DBXTypeNotSupported for every large object even if we could really
> >> > support
> >> > it.
> >>
> >> .... and this includes nvarchar? This doesn't need the large object
> >> functiuon calls does it? doesn't really matter. If it's assigned
> >> unknown then it needs to be handled anyway.
> >
> >
> >
> > grrrr sorry my bad. I got confused about large objects...
> > OpenDBX has a list of supported types, that you can check here:
> > http://www.linuxnetworks.de/doc/index.php/OpenDBX/DBMS_Datatypes
> >
> > nvarchar is not even mentioned there :(
> > So I guess it is not supported. But as said, try it overwritting
> > createDataTypesMap. And tell us what happens.
> > If it doesn't work, we can ask Norbert (OpenDBX developer) since he is
> > always very helpful.
> >
> > --
> > Mariano
> > http://marianopeck.wordpress.com
> >
> >
> > _______________________________________________
> > SqueakDBX mailing list
> > SqueakDBX at lists.squeakfoundation.org
> > http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx
> >
> >
> _______________________________________________
> SqueakDBX mailing list
> SqueakDBX at lists.squeakfoundation.org
> http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx
> --
> Mariano
> http://marianopeck.wordpress.com
> --
> Mariano
> http://marianopeck.wordpress.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/squeakdbx/attachments/20110505/87d9451a/attachment.htm
More information about the SqueakDBX
mailing list