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