I need to revoke most of my post below. What I found out afterwards is this:
1. if you do not use mysql_set_char mysql will NOT do any translations and thus store a utf8-character-byte as is. If you then retrieve this byte from the db and output it in a utf8 page it will show just fine BUT if other apps query this byte (expecting to find a latin1 byte) they will go wrong.
2. the 'bug' mentioned before only occurs if you use a ucase or lcase function in your statement (like: latin1_col = ucase('utf8 string')
Hope this helps, Ronald
----
Server IP: 89.248.170.61
Probable Submitter: 164.140.159.143
----
Manual Page -- http://www.php.net/manual/en/function.mysql-set-charset.php
Edit -- https://master.php.net/note/edit/86151
Del: integrated -- https://master.php.net/note/delete/86151/integrated
Del: useless -- https://master.php.net/note/delete/86151/useless
Del: bad code -- https://master.php.net/note/delete/86151/bad+code
Del: spam -- https://master.php.net/note/delete/86151/spam
Del: non-english -- https://master.php.net/note/delete/86151/non-english
Del: in docs -- https://master.php.net/note/delete/86151/in+docs
Del: other reasons-- https://master.php.net/note/delete/86151
Reject -- https://master.php.net/note/reject/86151
Search -- https://master.php.net/manage/user-notes.php
lmpx.com only provides a reader for public news (NNTP) servers. It is not
affiliated with the servers or forums shown here and is not responsible for
the content of articles, which is written by their respective authors.