BLOB Text data codepage conversion for SQL_C_WCHAR

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

BLOB Text data codepage conversion for SQL_C_WCHAR

Jojakim Stahl-3
Dear specialists,
I need your advice for the following problem:

(see also http://tracker.firebirdsql.org/browse/ODBC-161)

I bound a BLOB SUB_TYPE 1 CHARACHTER SET UTF8 field to SQL_C_WCHAR /
SQL_LONGVARCHAR via SQLBindParameter on an insert operation. Then encountered
problems when using SQLPutData to put in my chardata. Connection charset is
UTF8.

1. I found, that in the IPD the concise type is set to SQL_C_BINARY. Is this
also a good/valid choice for BLOB SUB_TYPE 1, or for this BLOB type wouldn't
it be better to set it to SQL_C_CHAR?

2. The wcstombs and vice versa codepage translation function is setup with a
call to getAdressWcsToMbs / getAdressMbsToWcs which in turn passes
qlda->getSubType( index ) to adressWcsToMbs/adressMbsToWcs. For normal CHAR
or VARCHAR database fields, the subtype contains 3=UNICODE_FSS or 4=UTF8 or
in general I assume the fb charset id. But in the case of BLOB, subtype is
not used to indicate the specified BLOB SUB_TYPE (again, I can't prove but I
assume based on the values found while debugging). So my question is, how, in
case of a BLOB, I can find the fb charset id to use, and then make a link to
the correct codepage conversion function?

All thanks for your help !

--
Joja


------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013
and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb
_______________________________________________
Firebird-odbc-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
Reply | Threaded
Open this post in threaded view
|

Re: BLOB Text data codepage conversion for SQL_C_WCHAR

Jojakim Stahl-3
On 07.02.2013 12:14:06, "Jojakim" wrote:
> ...But in the case of BLOB,
> subtype is not used to indicate the specified BLOB SUB_TYPE ...

Sorry, there is a typo: Must be:

But in the case of BLOB, subtype _is_ used to indicate the specified BLOB
SUB_TYPE


------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013
and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb
_______________________________________________
Firebird-odbc-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel