Hi again,
I tried add Standard page with some polish chars in title.
And that was OK but any operation - permissions, making live, deleting
are finish something like is a bottom:
[codebox]
Fatal error: [ASSERT EXCEPTION] DB Error: unknown error
UPDATE sq_hipo_job SET hipo_vars = 'a:9:{s:12:"current_step";i:0;s:12:"percent_done";d:25;s:15:"initialise_mode";s:3:"web";s:12:"running_mode";s:3:"web";s:7:"aborted";b:0;s:13:"server_taskid";s:0:"";s:7:"message";s:0:"";s:7:"job_dir";s:54:"/usr/local/www/apache22/mysource_matrix/core/hipo/jobs";s:6:"errors";a:1:{i:0;a:3:{s:4:"time";i:1200768234;s:7:"message";s:993:"[ASSERT EXCEPTION] DB Error: unknown error UPDATE sq_hipo_job SET hipo_vars = ''a:9:{s:12:"current_step";i:0;s:12:"percent_done";d:25;s:15:"initialise_mode";s:3:"web";s:12:"running_mode";s:3:"web";s:7:"aborted";b:0;s:13:"server_taskid";s:0:"";s:7:"message";s:0:"";s:7:"job_dir";s:54:"[SYSTEM_ROOT]/core/hipo/jobs";s:6:"errors";a:0:{}}'', options = ''a:2:{s:15:"on_complete_url";s:149:"/__adm/?SQ_BACKEND_PAGE=main&backend_section=am&am_section=edit_asset&assetid=112&asset_ei_screen=paths&sq_link_path=,0,96,125&sq_asset_path=1,92,112";s in /usr/local/www/apache22/mysource_matrix/core/include/locale_manager.inc on line 504[/codebox]
in pgsql log I have:
[codebox]Jan 19 19:43:54 thor postgres[77571]: [2-1] ERROR: invalid byte sequence for encoding "UTF8": 0x82
Jan 19 19:43:54 thor postgres[77571]: [2-2] HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled
Jan 19 19:43:54 thor postgres[77571]: [2-3] by "client_encoding".
Jan 19 19:43:54 thor postgres[77571]: [3-1] ERROR: invalid byte sequence for encoding "UTF8": 0x82
Jan 19 19:43:54 thor postgres[77571]: [3-2] HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled
Jan 19 19:43:54 thor postgres[77571]: [3-3] by "client_encoding".[/codebox]
PGSQL was init with encoding "–encoding=utf-8 "
It is default setting for pgsql on FreeBSD
[root@thor ~]# pkg_info | grep postgr
postgresql-client-8.2.6_1 PostgreSQL database (client)
postgresql-server-8.2.6 The most advanced open-source database available anywhere
[root@thor ~]#
In main.inc I have:
define('SQ_CONF_DEFAULT_CHARACTER_SET', 'utf-8');
In apache config I have:
DefaultLanguage pl
AddDefaultCharset utf-8
And in LanguagePriority I set pl as first
Links says:
[codebox]
| Codepage: Unicode UTF-8 |
| Content-Type: text/html; charset=utf-8 |
| Server: Apache |
[/codebox]
Maybe I did something wrong?
Regards
Arek
UTF8 problem?
I solved this problem - almost 
I reinstall matrix and create new DB ut this time I set encoding LATIN2
(ISO-8859-2) - now i can create standard page with polish chars in Page name
News items with polish chars in title are work too.
I have now:
PHP Warning
htmlentities() [function.htmlentities]: charset `iso-8859-2' not supported, assuming iso-8859-1
I setup in main.inc:
define('SQ_CONF_DEFAULT_CHARACTER_SET', 'iso-8859-2');
At this moment it is only annoying - content, titles and etc. with polish chars are
stored correct in DB and their are display correct.
Regards
Arek
If you leave the backend encoding as utf-8, do the chars show correctly?
[codebox][root@thor ~]# pkg_info | egrep "php|pear" -i
libmcrypt-2.5.8 Multi-cipher cryptographic library (used in PHP)
pear-1.6.2_1 PEAR framework for PHP
pear-DB-1.7.13,1 PEAR Database Abstraction Layer
pear-File_Archive-1.5.3 PEAR class to manipulate tar, gz, tgz, bz2, tbz, zip, ar (d
pear-MIME_Type-1.0.0 PEAR class for dealing with MIME types
pear-Mail-1.1.14 PEAR class that provides multiple interfaces for sending em
pear-Mail_Mime-1.5.2,1 PEAR classes to create and decode MIME messages
pear-Text_Diff-0.2.1 Engine for performing and rendering text diffs
pear-XML_HTMLSax-2.1.2 PEAR SAX parser for HTML and other badly formed XML documen
pear-XML_Parser-1.2.8 PEAR XML parsing class based on PHP's bundled expat
php4-4.4.8 PHP Scripting Language (Apache Module and CLI)
php4-bcmath-4.4.8 The bcmath shared extension for php
php4-ctype-4.4.8 The ctype shared extension for php
php4-curl-4.4.8 The curl shared extension for php
php4-extensions-1.0 A "meta-port" to install PHP extensions
php4-gd-4.4.8 The gd shared extension for php
php4-mbstring-4.4.8 The mbstring shared extension for php
php4-overload-4.4.8 The overload shared extension for php
php4-pcre-4.4.8 The pcre shared extension for php
php4-pgsql-4.4.8 The pgsql shared extension for php
php4-posix-4.4.8 The posix shared extension for php
php4-pspell-4.4.8 The pspell shared extension for php
php4-session-4.4.8 The session shared extension for php
php4-shmop-4.4.8 The shmop shared extension for php
php4-sockets-4.4.8 The sockets shared extension for php
php4-tokenizer-4.4.8 The tokenizer shared extension for php
php4-wddx-4.4.8 The wddx shared extension for php
php4-xml-4.4.8 The xml shared extension for php
php4-zlib-4.4.8 The zlib shared extension for php
[root@thor ~]#[/codebox]
All installed form ports tree.
Regards
Arek
Thank you Greg
Now I have UTF working fine 
All polish chars are displayed and stored in DB/files correct
I hope that was my last problem with PL chars.
Best regards
Arek
[quote]Thank you Greg
Now I have UTF working fine
All polish chars are displayed and stored in DB/files correct
I hope that was my last problem with PL chars.
Best regards
Arek[/quote]
As far as I remember I've solved all possible problems with Polish characters, so if you have any further questions let us know!