Re: type unknown - how important is it?

Shachar Shemesh wrote:

> Dave Cramer wrote:
>
>> Shachar,
>>
>> I think with type oid 705 (unknown) it's safe to treat it as text.
>> Certainly better than punting.
>
>
> Question is what DBTYPE to report it as. Options are DBTYPE_WSTR
> (UTF-16 string, which means the input string must be a valid UTF-8
> string), DBTYPE_STR (just dump it as I get it, and hope that client
> doesn't barf on the UTF-8 encoding), DBTYPE_BYTES (it's an array of
> bytes, just let the client figure out what to do with it. No promises
> on my part).
>
> I don't know type 705 well enough to decide which would work best. If
> it's guaranteed to be a validly encoded text string, then I'll just
> put it in as DBTYPE_WSTR, and get it done with.

Oh, if you want to look it up yourself:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/oledbdata_types.asp

Shachar

--
Shachar Shemesh
Lingnu Open Source Consulting ltd.
Have you backed up today's work? http://www.lingnu.com/backup.html