Dear Fu,

Version OpenCA-0.9.2 is still as perfect as it could be about utf-8 
stuff you need, and you can always downgrade to it unless you know why 
you should not.

Also a couple of old HowTo's about uft-8 in OpenCA and in popular 
databases could be of help:

http://www.openxpki.org/legacy/docs.html

All the best, Sergei

f u wrote:
> Hi, people. I have installed Openca 1.0.2 and have one essential problem with 
> it.
> I need to have certificates with russian characters in CN (=Вася Пупкин for 
> ex.).
> The problem was introduced in "Problems about multi-bytes language contents" 
> subject mail.
> There was a workaround, but it doesn't works for me.
>
> Workaround:
> Re: Problems about multi-bytes language contents
> Click to flag this post
>
> by wking Dec 04, 2008; 12:07pm :: Rate this Message: - Use ratings to 
> moderate (?)
>
> Reply | Reply to Author | Print | View Threaded | Show Only this Message
> 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");
>
> END of workaround.
>
> The problem is strange. I've set debug flag in DBI.pm,
> So in logs i can see normal Russian characters, but in the database it looks 
> like it's not utf-8: "Русский ЯÐ?ык"
>
> Database postgresql 8.3 full unicode.
> OS: FreeBSD 7.2
>
> Please say me: where to dig?!
> Thank You!
>
> ------------------------------------------------------------------------------
> Crystal Reports - New Free Runtime and 30 Day Trial
> Check out the new simplified licensing option that enables unlimited
> royalty-free distribution of the report engine for externally facing 
> server and web deployment.
> http://p.sf.net/sfu/businessobjects
> _______________________________________________
> Openca-Users mailing list
> Openca-Users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/openca-users
>   



------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Openca-Users mailing list
Openca-Users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openca-users

Reply via email to