bigpresh / bigpresh/Dancer-Plugin-Database

database() requires manual setting of UTF-8 mode even with charset: "UTF-8" in place

Open
#73 10 comments 0 reactions 0 assignees View on GitHub
Dominant language
Perl
Stars
39
Forks
36
PR merge metrics
No merged PRs in 30d

Description

Greetings!

The POD says:

> if your application is configured to use UTF-8 (you've defined the charset setting in your app config as UTF-8) then support for UTF-8 for the database connection will be enabled, if we know how to do so for the database driver in use.

however (in GWT format):

Given config.yml has `charset: "UTF-8"`
and
Given an SQLite database with proper utf-8 data
When I use `database( { driver => 'SQLite', database => $path_to_db })`
Then the data is garbled until I `$dbh->{sqlite_unicode} = 1;` w/ the handle it returns.

May be SQLite specific or not, not sure ATM.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.