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

[Mariano Martinez Peck]

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: <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
>
>


-- 
Mariano
http://marianopeck.wordpress.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/squeakdbx/attachments/20110505/91c04610/attachment.htm