diff options
Diffstat (limited to 't/rt_25371_asymmetric_unicode.t')
-rw-r--r-- | t/rt_25371_asymmetric_unicode.t | 38 |
1 files changed, 38 insertions, 0 deletions
diff --git a/t/rt_25371_asymmetric_unicode.t b/t/rt_25371_asymmetric_unicode.t new file mode 100644 index 0000000..40736f1 --- /dev/null +++ b/t/rt_25371_asymmetric_unicode.t @@ -0,0 +1,38 @@ +#!/usr/bin/perl + +use strict; +BEGIN { + $| = 1; + $^W = 1; +} + +use t::lib::Test; +use Test::More; +BEGIN { + if ( $] >= 5.008005 ) { + plan( tests => 23 ); + } else { + plan( skip_all => 'Unicode is not supported before 5.8.5' ); + } +} +use Test::NoWarnings; + +my $dbh = connect_ok( sqlite_unicode => 1 ); +is( $dbh->{sqlite_unicode}, 1, 'Unicode is on' ); + +ok( $dbh->do(<<'END_SQL'), 'CREATE TABLE' ); +CREATE TABLE foo ( + bar varchar(255) +) +END_SQL + +foreach ( "\0", "A", "\xe9", "\x{20ac}" ) { + ok( $dbh->do("INSERT INTO foo VALUES ( ? )", {}, $_), 'INSERT' ); + my $foo = $dbh->selectall_arrayref("SELECT bar FROM foo"); + is_deeply( $foo, [ [ $_ ] ], 'Value round-tripped ok' ); + my $len = $dbh->selectall_arrayref("SELECT length(bar) FROM foo"); + is $len->[0][0], 1 unless $_ eq "\0"; + my $match = $dbh->selectall_arrayref("SELECT bar FROM foo WHERE bar = ?", {}, $_); + is $match->[0][0], $_; + ok( $dbh->do("DELETE FROM foo"), 'DELETE ok' ); +} |