mirror of
https://github.com/DBD-SQLite/DBD-SQLite
synced 2025-06-07 14:19:10 -04:00
9dc75eaead
Issue #78 and issue #68: This introduces additional, more robust schemas for translating strings between SQLite and Perl.
33 lines
1.1 KiB
Perl
33 lines
1.1 KiB
Perl
# According to the sqlite doc, the SQL argument to sqlite3_prepare_v2
|
|
# should be in utf8, but DBD::SQLite does not ensure this (even with
|
|
# sqlite_unicode => 1). Only bind values are properly converted.
|
|
|
|
use strict;
|
|
use warnings;
|
|
use lib "t/lib";
|
|
use SQLiteTest;
|
|
use Test::More;
|
|
use if -d ".git", "Test::FailWarnings";
|
|
|
|
BEGIN { requires_unicode_support() }
|
|
|
|
my $dbh = connect_ok( sqlite_string_mode => DBD::SQLite::Constants::DBD_SQLITE_STRING_MODE_UNICODE_NAIVE );
|
|
is( $dbh->{sqlite_string_mode}, DBD::SQLite::Constants::DBD_SQLITE_STRING_MODE_UNICODE_NAIVE, 'Unicode is on' );
|
|
|
|
ok( $dbh->do(<<'END_SQL'), 'CREATE TABLE' );
|
|
CREATE TABLE foo (
|
|
bar varchar(255)
|
|
)
|
|
END_SQL
|
|
|
|
foreach ( "A", "\xe9", "\x{20ac}" ) {
|
|
note sprintf "testing \\x{%x}", ord($_);
|
|
ok( $dbh->do("INSERT INTO foo VALUES ( ? )", {}, $_), 'INSERT with bind' );
|
|
ok( $dbh->do("INSERT INTO foo VALUES ( '$_' )"), 'INSERT without bind' );
|
|
my $vals = $dbh->selectcol_arrayref("SELECT bar FROM foo");
|
|
is $vals->[0], $vals->[1], "both values are equal";
|
|
|
|
ok( $dbh->do("DELETE FROM foo"), 'DELETE ok' );
|
|
}
|
|
|
|
done_testing;
|