« links for 2006-08-04 | Main | 93% »

links for 2006-08-09

August 9, 2006 10:18 AM


(August 10, 2006 12:14 AM #)

yeah... PHP just sucks. The main problem this guy had (even though he didn't find it unfortunately) is that if you're using PHP's mysql_* functions instead of mysqli_*, PHP won't use MySQL's new binary protocol and therefor don't send a character set header. The ugly work-around is to set the client charset on every connection.

Now... if mysqli's parameter binding wasn't so f*(%§$d up that wouldn't be a problem.

In his case, if the table's default character set is UTF8, mysql will take the UTF8 data that comes through his latin1-encoded connection and reencode it into jumbled characters.

But all of that doesn't matter as MySQL's unicode support sucks as well (they only support 3-byte characters and therefor don't support all of Unicode's extended plane). The truth: he lost that battle already when he started using PHP.

Post a comment

(you may use HTML tags for style)

Remember Me?

Trackback Pings

TrackBack URL for this entry: