Mailing List Archive

Problems with utf8 and Loc
Hi all!

I stumbled into problems when having special characters (åäö and ÅÄÖ) in
the locale-table. They won't get translated correctly, but o get onstead
characters like Ã¥ ä ö Ã? Ã? Ã..

Is there any other setting than MINIVEND_DISABLE_UTF8=0 that i should
"turn on"?

I'm using the latest git-version from github. The database in postgres
9.4 is defined with UTF8 encoding.

Regards,

René

_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users
Re: Problems with utf8 and Loc [ In reply to ]
On 16.02.2018 02:06, René wrote:
> Hi all!
>
> I stumbled into problems when having special characters (åäö and ÅÄÖ) in
> the locale-table. They won't get translated correctly, but o get onstead
> characters like Ã¥ ä ö Ã? Ã? Ã..
>
> Is there any other setting than MINIVEND_DISABLE_UTF8=0 that i should
> "turn on"?
>
> I'm using the latest git-version from github. The database in postgres
> 9.4 is defined with UTF8 encoding.
>
> Regards,
>
> René

Forgot to mention that in have in catalog.cfg these settings

Variable MV_UTF8 1
Variable MV_HTTP_CHARSET UTF-8

Regards,

René


_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users
Re: Problems with utf8 and Loc [ In reply to ]
On Fri, 16 Feb 2018, René wrote:

>> I stumbled into problems when having special characters (åäö and ÅÄÖ)
>> in the locale-table. They won't get translated correctly, but o get
>> onstead characters like Ã¥ ä ö Ã? Ã? Ã..
>>
>> Is there any other setting than MINIVEND_DISABLE_UTF8=0 that i should
>> "turn on"?
>>
>> I'm using the latest git-version from github. The database in postgres
>> 9.4 is defined with UTF8 encoding.
>
> Forgot to mention that in have in catalog.cfg these settings
>
> Variable MV_UTF8 1
> Variable MV_HTTP_CHARSET UTF-8

Hi, René!

When using Postgres, you should also have this set in catalog.cfg:

DatabaseDefault PG_ENABLE_UTF8 1

which tells DBD::Pg to decode text from the database as UTF-8 in Perl.

Jon


--
Jon Jensen
End Point Corporation
https://www.endpoint.com/
Re: Problems with utf8 and Loc [ In reply to ]
> Hi, René!
>
> When using Postgres, you should also have this set in catalog.cfg:
>
> DatabaseDefault PG_ENABLE_UTF8 1
>
> which tells DBD::Pg to decode text from the database as UTF-8 in Perl.
>
> Jon

Hi Jon,

The PG_ENABLE_UTF8 was already set in dbconf/pgsql/pgsql.cfg. How it
looks to me is that it's somehow related to my GDBM, because i tested it
on the demo@icdevgroup, and there all worked as it should..

I also tried to remove and re-create the gdbm-files, but that did not work

I run a locally compiled perl 5.14.2, GDM 1.14, DBI 1.636..

René

_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users
Re: Problems with utf8 and Loc [ In reply to ]
> > Hi, René!
> >
> > When using Postgres, you should also have this set in catalog.cfg:
> >
> > DatabaseDefault PG_ENABLE_UTF8 1
> >
> > which tells DBD::Pg to decode text from the database as UTF-8 in Perl.
> >
> > Jon
>
> Hi Jon,
>
> The PG_ENABLE_UTF8 was already set in dbconf/pgsql/pgsql.cfg. How it looks
> to me is that it's somehow related to my GDBM, because i tested it on the
> demo@icdevgroup, and there all worked as it should..
>
> I also tried to remove and re-create the gdbm-files, but that did not work
>
> I run a locally compiled perl 5.14.2, GDM 1.14, DBI 1.636..
>
> René

Hi René

I also have this in my catalog.cfg:
DatabaseDefault GDBM_ENABLE_UTF8 1

Don't remember seeing this in your previous emails.

CU,

Gert


_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users
Re: Problems with utf8 and Loc [ In reply to ]
On 17.02.2018 20:59, Gert van der Spoel wrote:
> Hi René
>
> I also have this in my catalog.cfg:
> DatabaseDefault GDBM_ENABLE_UTF8 1
>
> Don't remember seeing this in your previous emails.

Hi Gert!

Long time no see!

Grepping through the ic-source, there is no such setting as
GDBM_ENABLE_UTF8. The only ENABLE_UTF8 i found in the source was
MYSQL_ENABLE_UTF8 and PG_ENABLE_UTF8..

Regards,

René

_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users
Re: Problems with utf8 and Loc [ In reply to ]
> -----Original Message-----
> From: interchange-users-bounces@icdevgroup.org [mailto:interchange-users-
> bounces@icdevgroup.org] On Behalf Of René
> Sent: Sunday, February 18, 2018 12:22
> To: interchange-users@icdevgroup.org
> Subject: Re: [ic] Problems with utf8 and Loc
>
>
> On 17.02.2018 20:59, Gert van der Spoel wrote:
> > Hi René
> >
> > I also have this in my catalog.cfg:
> > DatabaseDefault GDBM_ENABLE_UTF8 1
> >
> > Don't remember seeing this in your previous emails.
>
> Hi Gert!
>
> Long time no see!
>
> Grepping through the ic-source, there is no such setting as
> GDBM_ENABLE_UTF8. The only ENABLE_UTF8 i found in the source was
> MYSQL_ENABLE_UTF8 and PG_ENABLE_UTF8..
>
> Regards,
>
> René

Right it was removed about 1,5 years ago:
https://github.com/interchange/interchange/commit/25f07cb57a7347398cd92ffaf42c25aa08f58c82#diff-76993724690052d82c3c955427007768

Then I can't be of any big assistance, I've not dared to update the site I'm running, which seems to be doing fine with UTF-8 ... Perhaps there is a way to get these dbm files to be converted to normal mysql tables so all is in the database and things will work as-is that way all being mysql ...

Else hopefully someone else has an idea to solve the problems further!

Good luck!

CU,

Gert



_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users
Re: Problems with utf8 and Loc [ In reply to ]
On 18.02.2018 16:16, Gert van der Spoel wrote:
> Right it was removed about 1,5 years ago:
> https://github.com/interchange/interchange/commit/25f07cb57a7347398cd92ffaf42c25aa08f58c82#diff-76993724690052d82c3c955427007768
>
> Then I can't be of any big assistance, I've not dared to update the site I'm running, which seems to be doing fine with UTF-8 ... Perhaps there is a way to get these dbm files to be converted to normal mysql tables so all is in the database and things will work as-is that way all being mysql ...
>
> Else hopefully someone else has an idea to solve the problems further!
>
> Good luck!
>
> CU,
>
> Gert
I wonder if it has to do whth the gdbm-version.. Maybe i should
downgrade GDBM to the same version the demo.icdevgroup.org-server is using?

René




_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users