[fdo-internals] Discussion of fix for ticket #471 (Large text fields not showing up)

[Chris Erickson]

Romica,
Thanks, I've followed and done that, except I'm mapping it to a FDO CLOB, is this incorrect?

One problem, the column length returned by the sde sdk is 0, but arccatalog recognizes it as 1073741822 (unlimited?).  Should I just add a special case for this (if (datatype == CLOB and length == 0) length = SOME_BIG_NUMBER))?  The SDE SDK documentation (so surprisingly) is silent on the issue.


chris erickson
developer
chris at cartopac.com
970.493.9500 x 191
970.482.1485 (fax)



-----Original Message-----
From: fdo-internals-bounces at lists.osgeo.org [mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Romica Dascalescu
Sent: Thursday, March 05, 2009 9:04 AM
To: FDO Internals Mail List
Subject: RE: [fdo-internals] Discussion of fix for ticket #471 (Large text fields not showing up)

Hi Chris,

SDE_UNICODE is set only for 9.2 provider, since 9.1 SDE libraries don't support Unicode.
ArcSDE 9.2 provider is built enabling unicode support.
In case you want to add support for SE_NCLOB_TYPE you need to look at SE_NSTRING_TYPE, where was added (since it was added late in the provider) and do the same thing.

Regards,
Romi.

________________________________
From: fdo-internals-bounces at lists.osgeo.org [fdo-internals-bounces at lists.osgeo.org] On Behalf Of Chris Erickson [chris at cartopac.com]
Sent: Thursday, March 05, 2009 11:02 AM
To: fdo-internals at lists.osgeo.org
Subject: [fdo-internals] Discussion of fix for ticket #471 (Large text fields not showing up)

Hello,
I'm working on fixing tix # 471, and have the following question.


The problem is in SDEType2FdoType.  There is no handler for the SE_NCLOB_TYPE, which is defined as:



#define SE_NCLOB_TYPE              15  /* UNICODE Character Large Object */



I see another place in here, where the SE_NSTRING_TYPE is handled, but ifdef'ed out when SDE_UNICODE is not set.



My question is this,

When is SDE_UNICODE set?



[cid:image001.png at 01C99D71.0F3BEAA0]<http://www.cartopac.com/>

chris erickson
developer
chris at cartopac.com<mailto:chris at cartopac.com>
970.493.9500 x 191
970.482.1485 (fax)