<br><br><div class="gmail_quote">On Fri, Apr 29, 2011 at 3:53 PM, Miguel Sanchez <span dir="ltr"><<a href="mailto:mikey.sanchez@gmail.com">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;">
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">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">squeakdbx@lists.squeakfoundation.org</a>><br>
> Message-ID: <BANLkTi=jeTSo2UOvchsyc=Mp=<a href="mailto:WbRtfRVxw@mail.gmail.com">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 clear.<br>
<br>
My apologies for the newbie questions and generally being dense about<br>
understanding the code.<br>
<br></blockquote><div><br>your questions are very welcome. <br> </div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
><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>) 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 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></blockquote><div><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: <a href="http://www.linuxnetworks.de/doc/index.php/OpenDBX/DBMS_Datatypes">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 createDataTypesMap. And tell us what happens.<br>If it doesn't work, we can ask Norbert (OpenDBX developer) since he is always very helpful. <br>
<br></div></div>-- <br>Mariano<br><a href="http://marianopeck.wordpress.com" target="_blank">http://marianopeck.wordpress.com</a><br><br>