6.0.0-alpha12
6/7/25

[#6422] ? replaces non-ascii chars
Summary ? replaces non-ascii chars
Queue Turba
Queue Version HEAD
Type Bug
State Not A Bug
Priority 1. Low
Owners
Requester andrzej.dzik (at) ekspert (dot) szczecin (dot) pl
Created 03/10/2008 (6298 days ago)
Due
Updated 03/11/2008 (6297 days ago)
Assigned 03/10/2008 (6298 days ago)
Resolved 03/11/2008 (6297 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
03/11/2008 11:25:36 AM andrzej (dot) dzik (at) ekspert (dot) szczecin (dot) pl Comment #7 Reply to this comment
Mysql php extension don't have charset param in mysql_connect

It have in php5 mysql_set_charset function



Look at

http://php.oregonstate.edu/manual/en/function.mysql-client-encoding.php

http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html


03/11/2008 10:32:40 AM Jan Schneider Comment #6 Reply to this comment
Then either your data is not stored as latin2 in the backend, or the 
PHP extensions don't understand "latin2" as a valid charset (try 
ISO-8859-2 instead), or you have an interface charset in Horde to that 
latin2 characters can't be converted losslessly. For further support 
ask on the mailing list please.
03/11/2008 10:15:46 AM andrzej (dot) dzik (at) ekspert (dot) szczecin (dot) pl Comment #5 Reply to this comment
I have in horde configuration

$conf['sql']['phptype'] = 'mysql';

$conf['sql']['charset'] = 'latin2';



but without my patch I see ? in place of latin2 chars
03/11/2008 10:01:11 AM Jan Schneider Comment #4
State ⇒ Not A Bug
Reply to this comment
Turba works perfectly if you specify the correct charset in the SQL 
configuration
03/11/2008 09:15:15 AM andrzej (dot) dzik (at) ekspert (dot) szczecin (dot) pl Comment #3 Reply to this comment
mysql --default-character-set=utf8 -u horde -p horde

select object_name from turba_objects;

Jaś Kowalski



Turba show

Ja? Kowalski



My patch is for /usr/share/horde3/turba/lib/Driver/sql.php



after patch Turba show

Jaś Kowalski


03/10/2008 10:37:07 PM Jan Schneider Comment #2
State ⇒ Feedback
Reply to this comment
Please use more words, I am not sure what you are trying to fix.
03/10/2008 08:32:17 PM andrzej (dot) dzik (at) ekspert (dot) szczecin (dot) pl Comment #1
Priority ⇒ 1. Low
Type ⇒ Bug
Summary ⇒ ? replaces non-ascii chars
Queue ⇒ Turba
Milestone ⇒
Patch ⇒ No
State ⇒ Unconfirmed
Reply to this comment
Database (mysql) in non ascii encoding (latin2). Turba shows ? in 
place of non-ascii chars.

Patch

77a78,80
             if ($params['phptype'] == 'mysql') {
                 $this->_db->query("set names ".$this->_params['charset']);
             }

Saved Queries