1 files changed, 45 insertions, 0 deletions
diff --git a/t/rt_25924_user_defined_func_unicode.t b/t/rt_25924_user_defined_func_unicode.t
new file mode 100644
index 0000000..fba2ef0
--- /dev/null
+++ b/t/rt_25924_user_defined_func_unicode.t
@@ -0,0 +1,45 @@
+#!/usr/bin/perl
+
+use strict;
+BEGIN {
+	$|  = 1;
+	$^W = 1;
+}
+
+use t::lib::Test qw/connect_ok @CALL_FUNCS/;
+use Test::More;
+BEGIN {
+	if ( $] >= 5.008005 ) {
+		plan( tests => 15 * @CALL_FUNCS + 1);
+	} else {
+		plan( skip_all => 'Unicode is not supported before 5.8.5' );
+	}
+}
+use Test::NoWarnings;
+
+foreach my $call_func (@CALL_FUNCS) {
+	my $dbh = connect_ok( sqlite_unicode => 1 );
+	ok($dbh->$call_func( "perl_uc", 1, \&perl_uc, "create_function" ));
+
+	ok( $dbh->do(<<'END_SQL'), 'CREATE TABLE' );
+CREATE TABLE foo (
+	bar varchar(255)
+)
+END_SQL
+
+	my @words = qw{Bergère hôte hétaïre hêtre};
+	foreach my $word (@words) {
+		# rt48048: don't need to "use utf8" nor "require utf8"
+		utf8::upgrade($word);
+		ok( $dbh->do("INSERT INTO foo VALUES ( ? )", {}, $word), 'INSERT' );
+		my $foo = $dbh->selectall_arrayref("SELECT perl_uc(bar) FROM foo");
+		is_deeply( $foo, [ [ perl_uc($word) ] ], 'unicode upcase ok' );
+		ok( $dbh->do("DELETE FROM foo"), 'DELETE ok' );
+	}
+	$dbh->disconnect;
+}
+
+sub perl_uc {
+	my $string = shift;
+	return uc($string);
+}