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

[Miguel Sanchez]

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

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