Edit report at
http://pear.php.net/bugs/bug.php?id=16559&edit=1ID: 16559
Updated by:
[email protected]Reported By: daniel dot oconnor at gmail dot com
Summary: Unmigrated data vs UTF8 output
Status: Open
Type: Bug
Package: pearweb
Package Version: CVS
PHP Version: 5.2.5
Roadmap Versions:
New Comment:
[288045] does SET NAMES, whcih resolves the display of umlauts.
However, locally, the format-bug-strip-only-some-html stuff is broken
for Bug #12916
Previous Comments:
------------------------------------------------------------------------
[2009-09-04 10:17:02] cweiske
http://test.pear.php.net/pepr/http://test.pear.php.net/user/neptohttp://test.pear.php.net/user/padraic------------------------------------------------------------------------
[2009-09-04 10:08:33] cweiske
http://test.pear.php.net/support/books.php------------------------------------------------------------------------
[2009-09-04 10:07:32] cweiske
http://test.pear.php.net/qa/------------------------------------------------------------------------
[2009-09-02 09:48:58] cweiske
It could be we just need to "SET NAMES 'utf8'" and are done.
------------------------------------------------------------------------
[2009-09-01 10:00:44] doconnor
(4:56:03 PM) cweiske: do we use iconv?
(4:56:03 PM) cweiske: no
(4:56:48 PM) cweiske: it's an apache vhost estting
(5:23:05 PM) CloCkWeRX: alright; i think i have this straight in my
head
(5:23:21 PM) cweiske: CloCkWeRX, you do have access to sg1?
(5:23:26 PM) CloCkWeRX: not right now
(5:23:32 PM) cweiske: ohk
(5:24:26 PM) CloCkWeRX: 1) pearweb spat out ISO whatever for quite a
while, so bug reports form data was ISO when posted back, and stuck into
an ISO database
(5:24:26 PM) CloCkWeRX: 2) We swapped the table storage to UTF-8; using
an ALTER TABLE CONVERT TO CHARACTER SET; and migrated all of the data
then
(5:25:01 PM) cweiske: iso-8850-15
(5:25:04 PM) cweiske: iso-8859-15
(5:26:14 PM) CloCkWeRX: 3) time went by and we kept INSERTing ISO data
which was fine-ish (ie, pearweb still said it was ISO); even though
mysql allocated enough space to store it as (mangled) UTF8
(5:26:27 PM) cweiske: 3 sound possible
(5:26:52 PM) CloCkWeRX: 4) ; and now I've made pearweb say it's
producing UTF-8, which is actually ISO in the database / internal
handling; it gets rendered in its mangled UTF8 form to the browser; and
everyone has noticed :(
(5:27:26 PM) yunosh [
[email protected]] entered the
room.
(5:27:32 PM) CloCkWeRX: can you check the charset of the bugdb table to
see if #3 is likely?
(5:27:44 PM) cweiske: not now, having a meeting now
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://pear.php.net/bugs/bug.php?id=16559
