Re: Problem storing utf-8 in MySQL

2008-04-13 Thread Malcolm Tredinnick
On Sun, 2008-04-13 at 21:30 -0700, Rob Hudson wrote: > On Apr 13, 6:26 pm, Malcolm Tredinnick <[EMAIL PROTECTED]> > wrote: > > Do you mean that you are coming across a case of trying to store 4-byte > > UTF-8 sequences in MySQL? Or do you mean that you've managed to create a > > database table wi

Re: Problem storing utf-8 in MySQL

2008-04-13 Thread Rob Hudson
On Apr 13, 6:26 pm, Malcolm Tredinnick <[EMAIL PROTECTED]> wrote: > Do you mean that you are coming across a case of trying to store 4-byte > UTF-8 sequences in MySQL? Or do you mean that you've managed to create a > database table with the incorrect encoding and only realised this after > you've

Re: Problem storing utf-8 in MySQL

2008-04-13 Thread Malcolm Tredinnick
Rob, On Sun, 2008-04-13 at 13:28 -0700, Rob Hudson wrote: [...] > For those of us having a very similar problem elsewhere, what's a good > general solution? Depends on the general problem. :-) Do you mean that you are coming across a case of trying to store 4-byte UTF-8 sequences in MySQL? Or d

Re: Problem storing utf-8 in MySQL

2008-04-13 Thread Rob Hudson
On Mar 21, 4:19 pm, "Karen Tracey" <[EMAIL PROTECTED]> wrote: > OK, got it now.  Turns out the answer is in the clear-as-mud error message, > sort of: > > Warning: Incorrect string value: '\xF0\x90\x8C\xBC\xF0\x90...' > > x'f0908cbc' is a valid 4-byte UTF-8 value, only MySQL doesn't support 4-byte