Re: type unknown - how important is it? - Mailing list pgsql-hackers

From Shachar Shemesh
Subject Re: type unknown - how important is it?
Date
Msg-id 42392BE5.5040206@shemesh.biz
Whole thread Raw
In response to Re: type unknown - how important is it?  (Shachar Shemesh <psql@shemesh.biz>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Ali Baba
Date:
Subject: Exception handiling
Next
From: "Michael Paesold"
Date:
Subject: Re: [pgsql-hackers-win32] win32 performance - fsync question