> 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. But I want 1.0.2 for now! All I need is correct data insertion into Pg db. I don't think it will be very hard to find this bug. > Also a couple of old HowTo's about uft-8 in OpenCA and in popular > databases could be of help: Thank You. I'm running 3 copies (pub-ra-CA) of 0.9.3 in pilot mode. It's not so good as it could... I need something better. > http://www.openxpki.org/legacy/docs.html Is it alive? ( I mean 'openxpki' FreeBSD port was market as broken long time ago...) > All the best, Sergei Thanks in advance. > 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
