Hi Miguel. This is something that we really need to fix and make it clear.<br><br>I will try to explain: OpenDBX library have 4 special functions (check above in <a href="http://www.linuxnetworks.de/doc/index.php/OpenDBX/C_API/1.2">http://www.linuxnetworks.de/doc/index.php/OpenDBX/C_API/1.2</a>) when managing large objects WHEN the backend requires such.<br>
We wrongly understood that at the beginning. So...we throw DBXTypeNotSupported for every large object even if we could really support it.<br><br>So...a backend, i.e, a database client library, 1) can support large objects with the regular functions (like regular fields); 2) or need special functions to manage them (and hence, use the special functions of OpenDBX). We ONLY support 1) since we didn't yet wrap the OpenDBX functions for large objects. However, only Firebird is using those functions for large objects. ALL the rest of the backends, use 1), so we should support it. <br>
<br>Now...what is the problem? as I told you, we misunderstood that and therefore we directly throw DBXTypeNotSupported for every large object.<br>Take a look to DBXPlatform class >> createDataTypesMap<br>Now, "some" were already fixed. For example, createDataTypesMap overwrites #createDataTypesMap and fixes Clob and Blob.<br>
<br>Suggestion: take the DBXMSSQLPlatform, overwrite #createDataTypesMap and fix what you want.<br><br>Real solution we should do ? We should change DBXPlatform class >> createDataTypesMap and map ALL types, and the overwrite #createDataTypesMap in Firebird to trow erros (like it is now in DBXPlatform class >> createDataTypesMap).<br>
<br>Was that clear?<br><br>Last comment, depending what you are doing, you may not need to transform the values of a field and instead, get them as string. DBXRow >> #valueAt: and valueXXX DO the conversion from string to the tpype. However, #rawValueAt: and frinds, DO NOT. So, you can always use them and they will always work, but getting the value as String.<br>
<br>I entered issue:<br><br><a href="http://code.google.com/p/dbxtalk/issues/detail?id=3">http://code.google.com/p/dbxtalk/issues/detail?id=3</a><br><br>Thanks<br><br>Mariano<br><br><br><br><br><div class="gmail_quote">On Fri, Apr 29, 2011 at 10:20 AM, 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;">Hi all,<br>
<br>
I have a couple of problems but the second I'll pop in a second mail<br>
to have a clear subject line.<br>
<br>
I have a field on a table defined as nvarchar(50) that is throwing a<br>
DBXTypeNotSupported error despite the default supported type map on<br>
DBXPlatform which maps the datatype to a String. I've managed to avoid<br>
needing to select explicitly unsupported types (CLOB BLOC etc.....)<br>
<br>
My platform.<br>
Windows XP sp3<br>
Pharo 1.1.1 one-click<br>
DBXOdbcPlatform<br>
<br>
Database (on localhost):<br>
MSSQL 2005<br>
MSSQL<br>
<br>
Best Regards,<br>
<br>
<br>
Miguel<br>
_______________________________________________<br>
SqueakDBX mailing list<br>
<a href="mailto:SqueakDBX@lists.squeakfoundation.org">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>
</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>