Hello, list. I can't resolve that issue with fucked up characters written to the database. This 'dirty hack': >Re: Problems about multi-bytes language contents >.by wking Dec 04, 2008; 12:07pm :: Rate this Message: - Use ratings to >moderate (?) >Hi, all, > > After a week's day and night debug, I find out the cause at last. It's caused > by a mis-decoding of > parameters which is going to persistent into database from utf-8. > >I modified the OpenCA/DBI.pm of perl module. > >from Line 3085: > > # my @obind_values = @{$keys->{BIND_VALUES}} if ($keys->{BIND_VALUES}); > my @bind_values; > > foreach my $help ( @{$keys->{BIND_VALUES}}){ > # if the bind value is still in utf-8 , I decode it here. > if(Encode::is_utf8($help)){ > $help=Encode::decode_utf8($help); > } > $bind_values[ scalar( @bind_values)]=$help; > } > > > $self->debug ("doQuery: query: $query");
works only for linux and doesn't resolves the problem in the right way. It only recodes data to utf-8 just before commit. I need to know the real source of the problem and the right way to correct it. I need it to work on FreeBSD too. So, I tried, but no success. All I can do: is asking for your help. I'll give 50 euro to one, who will do it for me (paypal). I hope it's not so hard to correct this bug. Thank You. ------------------------------------------------------------------------------ _______________________________________________ Openca-Users mailing list Openca-Users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openca-users