Re: DBD::SQLite with Japanese Character problem

[Tatsuhiko Miyagawa]

At Tue, 26 Mar 2002 20:27:47 +0900,
KAWAI,Takanori <[EMAIL PROTECTED]> wrote:
> 
> I found these lines in "dbdimp.c" must be the point.
> 
> line : 375 - 381
>             sv_setpvn(AvARRAY(av)[i], val, len);
>             SvUTF8_on(AvARRAY(av)[i]);
>         }
>         else {
>             sv_setsv(AvARRAY(av)[i], Nullsv);
>             SvUTF8_on(AvARRAY(av)[i]);
>         }
> (included in sqlite_st_fetch)
> If I comment out "SvUTF8_on", it seems to be no problem.

Possible patch after sig. DISCLAIMER: I'm very bad in C/XS :(

--
Tatsuhiko Miyagawa <[EMAIL PROTECTED]>


--- dbdimp.c~   Tue Mar 26 20:59:20 2002
+++ dbdimp.c    Tue Mar 26 20:59:12 2002
@@ -188,7 +188,9 @@
             }
             else {
                 num_params++;
+#ifdef SQLITE_UTF8
                 SvUTF8_on(chunk);
+#endif
                 av_push(imp_sth->sql, chunk);
                 chunk = NEWSV(0, 20);
                 sv_setpvn(chunk, "", 0);
@@ -373,7 +375,9 @@
                 val[len] = '\0';
             }
             sv_setpvn(AvARRAY(av)[i], val, len);
+#ifdef SQLITE_UTF8
             SvUTF8_on(AvARRAY(av)[i]);
+#endif
         }
         else {
             sv_setsv(AvARRAY(av)[i], Nullsv);