Skip Menu |

Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

This queue is for tickets about the Dancer-Plugin-Database CPAN distribution.

Report information
The Basics
Id: 65779
Status: resolved
Priority: 0/
Queue: Dancer-Plugin-Database

People
Owner: Nobody in particular
Requestors: jury.gorky [...] gmail.com
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



Subject: UTF-8
Date: Wed, 16 Feb 2011 15:11:43 +0200
To: bug-Dancer-Plugin-Database [...] rt.cpan.org
From: Jury Gorky <jury.gorky [...] gmail.com>
It's not a bug, it's a suggestion I have a Dancer's config.yml with utf8 settings enabled: charset: "UTF-8" and engines: template_toolkit: encoding: "utf8" In this case when I select data from database and pass it to the template, it is corrupted The solution was to explicitly add "mysql_enable_utf8: 1" to dbi_params in config file. I think that the plugin could make use of the common Dancer 'charset' setting, enabling utf for the database, or if it's not a good idea, the need of using mysql_enable_utf8 should be mentioned in documentation.
On Wed Feb 16 08:11:51 2011, jury.gorky@gmail.com wrote: Show quoted text
> I think that the plugin could make use of the common Dancer 'charset' > setting, enabling utf for the database, or if it's not a good idea, > the need of using mysql_enable_utf8 should be mentioned in > documentation.
You're absolutely right, and I'm already planning that: https://github.com/bigpresh/Dancer-Plugin-Database/issues#issue/6 I hope to get it done within the next few days and get another release out :) Thanks for the suggestion, appreciated. Any other feedback is very welcome, too! I'll leave this ticket open until the new feature is done. Cheers Dave P
On Wed Feb 16 08:17:17 2011, BIGPRESH wrote: Show quoted text
> On Wed Feb 16 08:11:51 2011, jury.gorky@gmail.com wrote:
> > I think that the plugin could make use of the common Dancer 'charset' > > setting, enabling utf for the database, or if it's not a good idea, > > the need of using mysql_enable_utf8 should be mentioned in > > documentation.
> > You're absolutely right, and I'm already planning that: > > https://github.com/bigpresh/Dancer-Plugin-Database/issues#issue/6 > > I hope to get it done within the next few days and get another release > out :)
I've just released 1.11_01 as a developer release, containing code to automatically enable UTF-8 if the application's charset is UTF-8 and the DB driver is SQLite, Pg or mysql. I'd greatly appreciate if you have time to test whether that works for you! Assuming all is well, I'll release this as 1.20 soon.
Subject: Re: [rt.cpan.org #65779] UTF-8
Date: Sat, 19 Feb 2011 16:07:57 +0200
To: bug-Dancer-Plugin-Database [...] rt.cpan.org
From: Jury Gorky <jury.gorky [...] gmail.com>
Yes, this works fine, thanks On 18 February 2011 23:32, David Precious via RT <bug-Dancer-Plugin-Database@rt.cpan.org> wrote: Show quoted text
> <URL: https://rt.cpan.org/Ticket/Display.html?id=65779 > > > On Wed Feb 16 08:17:17 2011, BIGPRESH wrote:
>> On Wed Feb 16 08:11:51 2011, jury.gorky@gmail.com wrote:
>> > I think that the plugin could make use of the common Dancer 'charset' >> > setting, enabling utf for the database, or if it's not a good idea, >> > the need of using mysql_enable_utf8 should be mentioned in >> > documentation.
>> >> You're absolutely right, and I'm already planning that: >> >> https://github.com/bigpresh/Dancer-Plugin-Database/issues#issue/6 >> >> I hope to get it done within the next few days and get another release >> out :)
> > I've just released 1.11_01 as a developer release, containing code to > automatically enable UTF-8 if the application's charset is UTF-8 and the > DB driver is SQLite, Pg or mysql. > > I'd greatly appreciate if you have time to test whether that works for you! > > Assuming all is well, I'll release this as 1.20 soon. > > >
On Sat Feb 19 09:08:07 2011, jury.gorky@gmail.com wrote: Show quoted text
> Yes, this works fine, thanks
Excellent, thanks for confirming! I'll get this released as 1.20 soon.
On Mon Feb 21 10:54:09 2011, BIGPRESH wrote: Show quoted text
> On Sat Feb 19 09:08:07 2011, jury.gorky@gmail.com wrote:
> > Yes, this works fine, thanks
> > Excellent, thanks for confirming! > > I'll get this released as 1.20 soon.
I've just released version 1.20 to CPAN. Thanks again for the suggestion and your feedback!