[Catalyst] CSV / UTF-8 / Unicode

[Craig Chant]

I looked at that link but it doesn't have anything on DBD::ODBC that I could see.

Interesting enough utf8::is_utf8($xls) returns true, but it isn't because the output is garbage?

Also as utf8::is_utf8 claims the string is UTF-8,  why does decode baulk with 'cannot decode string with wide characters'?


-----Original Message-----
From: Mike Whitaker [mailto:mike at altrion.org]
Sent: 02 July 2013 14:58
To: The elegant MVC web framework
Subject: Re: [Catalyst] CSV / UTF-8 / Unicode

On 2 Jul 2013, at 14:36, Mike Whitaker <mike at altrion.org> wrote:
> On 2 Jul 2013, at 14:34, Craig Chant <craig at homeloanpartnership.com> wrote:
>>
>> So either I refactor my SQL model wrappers under Catalyst to use Win32::ODBC, or I find out why DBI is corrupting my SQL data.
>
> Be a hero. Do the latter :D :D

..and have a read of http://juerd.nl/site.plp/perluniadvice

You may also find that calling utf8::is_utf8() on the strings that come back from your DB may be revealing (this is one case in which you may use this without people screaming NOOOOOOOO!), as may http://search.cpan.org/~ilyaz/Devel-Peek-0.96/Peek.pm for peeking into the innnards of Perl strings.


_______________________________________________
List: Catalyst at lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/
This Email and any attachments contain confidential information and is intended solely for the individual to whom it is addressed. If this Email has been misdirected, please notify the author as soon as possible. If you are not the intended recipient you must not disclose, distribute, copy, print or rely on any of the information contained, and all copies must be deleted immediately. Whilst we take reasonable steps to try to identify any software viruses, any attachments to this e-mail may nevertheless contain viruses, which our anti-virus software has failed to identify. You should therefore carry out your own anti-virus checks before opening any documents. HomeLoan Partnership will not accept any liability for damage caused by computer viruses emanating from any attachment or other document supplied with this e-mail. HomeLoan Partnership reserves the right to monitor and archive all e-mail communications through its network. No representative or employee of HomeLoan Partnership has the authority to enter into any contract on behalf of HomeLoan Partnership by email. HomeLoan Partnership is a trading name of H L Partnership Limited, registered in England and Wales with Registration Number 5011722. Registered office: 26-34 Old Street, London, EC1V 9QQ. H L Partnership Limited is authorised and regulated by the Financial Conduct Authority.