[Tickets #4555] Re: ISO-8859-1 and mySQL issue - stripped characters

[bugs@bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=4555
-----------------------------------------------------------------------
 Ticket             | 4555
 Updated By         | Jan Schneider <jan at horde.org>
 Summary            | ISO-8859-1 and mySQL issue - stripped characters
 Queue              | Horde Framework Packages
 Version            | HEAD
 Type               | Bug
-State              | Feedback
+State              | Not A Bug
 Priority           | 1. Low
-Owners             | 
+Owners             | 
-----------------------------------------------------------------------


Jan Schneider <jan at horde.org> (2006-10-26 02:38) wrote:

> And I tried echoing out the query, which gave me the insert query 
> with the values replaced by question marks (this was from the 
> Kronolith). The values array did include the correct letters (with 
> åäö).

OK, so the error is outside of Horde.

> However, I didn't find the query method from $this->_db. Now I think 
> I did though, it uses the PHP built in DB-handler (DB.php and 
> DB/mysql.php in my case in the PHP share directory), or, no?

Not built in PHP, but provided by the PEAR DB package. You can retrieve
the actual query sent to the DB server with $this->_db->last_query *after*
the $this->_db->query() call.

> Anyway, this is really confusing...
> Now I tried to insert an event and to my surprise it worked with 
> these letters... And I hadn't changed anything. The only thing that 
> had changed, that I know of, was my browser session but should that 
> matter? Is the server settings somehow stored in my session?

Yes.