On Fri, 27 Apr 2007, Mike Trotman wrote:
> I am writing a CGI application that uses WIN32::OLE to interface to
> Microsoft ADO, MS Access, SQL Server and MSXML for XML documents and
> XSLT transformations.
>
> I suspect that something in the way I am passing data around (or in
> the ADO implementation of 'savetoxml') is not dealing correctly with
> XML document encoding declarations. The data is originally in an MS
> Access database - but has been entered using copy and paste from MS
> Word documents from around the world - so contains many weird and
> wonderful bytes.
>
> To help in my debugging process can anyone tell me how WIN32::OLE
> deals with 'strings' returned from method calls? i.e.
> - are they pure byte data as output by the method (and maybe in UTF-16)?
> - or are they converted to Perl's internal format (using any current
> Perl encoding settings)?
> - or does something else happen?
>
> The problems I am having are primarily when outputting XML documents
> (or HTML) to send to the browser.
> e.g.my $OUTPUT=""; $OUTPUT=$xmldoc->transformNode($xsltsheet);
>
> print $OUTPUT;
All string data is converted to the current system codepage by
Win32::OLE before being passed back to Perl _unless_ you switch
Win32::OLE to Unicode mode first:
Win32::OLE->Option(CP => Win32::OLE::CP_UTF8());
After this call all strings are converted to UTF8 and marked as
such in the Perl internal flags.
Cheers,
-Jan
_______________________________________________
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
