FUDforum: comp.lang.php » Cannot write utf8 data into a utf8 column

Home » Imported messages » comp.lang.php » Cannot write utf8 data into a utf8 column

Show: Today's Messages :: Polls :: Message Navigator

Cannot write utf8 data into a utf8 column [message #170746]

Thu, 18 November 2010 16:54

Tony Marston
Messages: 57
Registered: November 2010

Karma:

Member

This is very strange. When I try this update in my PHP program:

UPDATE email_msg
SET size=771,
message_text='? ?:\n\n ????2010?11?25-26? ? ? ? 12?09-10? ? ? ?12?16-17?
?? ????:\n\n?
????2010???????2011????????????????????????? ????!\n\n?????????????????????????????????????????--?
? ?? ??!\n\n\n????????????:baoming_gz(at)126(dot)com??! ( ?????????!)??!
\n\n\n\n?-?-?-?:0-2-0--3-9-9-2-6-2-7-5?(0)1-3-7-1-9-0-2-5-4-7-6
??? ????\n\n?-?-?-?:baoming_gz(at)126(dot)com\n\n\n????????,?????"??"?"delete"?:tuidin01(at)163(dot)com
??!',
revised_date='2010-11-18 15:48:09',
revised_user='AJM'
WHERE email_id='159'

it fails with the following error:

"Incorrect string value: '\xA0\xA0 \xE6\x88\x91...' for column
'message_text' at row 1"

When I try the SAME update through SQL-Front or phpMyAdmin it works! Why is
this?

--
Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

[Message index]

		Cannot write utf8 data into a utf8 column By: Tony Marston on Thu, 18 November 2010 16:54
		Re: Cannot write utf8 data into a utf8 column By: Peter H. Coffin on Fri, 19 November 2010 03:25
		Re: Cannot write utf8 data into a utf8 column - SOLVED By: Tony Marston on Fri, 19 November 2010 16:25
		Re: Cannot write utf8 data into a utf8 column - SOLVED By: Michael Fesser on Fri, 19 November 2010 17:03
		Re: Cannot write utf8 data into a utf8 column - SOLVED By: Thomas 'PointedEars' on Fri, 19 November 2010 22:48

Previous Topic:	store backslash in mysql database
Next Topic:	Firewall - NetDefender :

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 15:51:41 GMT 2024

Total time taken to generate the page: 0.04226 seconds