[SqueakDBX] MSSQL, selecting nvarchar (other types too) field causes DBXTypeNotSupported.

[Mariano Martinez Peck]

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: <BANLkTi=jeTSo2UOvchsyc=Mp=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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/squeakdbx/attachments/20110429/87c7a8cd/attachment.htm