On Feb 12, 12:26 pm, "ronrsr" <[EMAIL PROTECTED]> wrote:
> I have an MySQL database called zingers. The structure is:
>
<snip>
> I am having trouble storing text, as typed in latter two fields.
> Special characters and punctuation all seem not to be stored and
> retrieved correctly.
>
> Special apostrophes and single quotes from Microsoft Word are causing
> a
> special problem, even though I have ''ed all 's
>
<snip>
>
> Input and output is through a browser.
>
<snip>
>
> UnicodeDecodeError: 'ascii' codec can't decode byte 0xe2 in position
> 95: ordinal not in range(128)
> args = ('ascii', "update zingers set keywords =
> 'a;Action;b;Religi... \n \n \n ' where zid = 422", 95, 96, 'ordinal
> not
> in range(128)')
> encoding = 'ascii'
> end = 96
> object = "update zingers set keywords = 'a;Action;b;Religi...
> \n
> \n \n ' where zid = 422"
> reason = 'ordinal not in range(128)'
> start = 95
>
> the characters I am trying to add are startquote and endquote copied
> and pasted from Microsoft Word.
>
<snip>
http://tinyurl.com/2g9364
as nobody has replied yet...perhaps the above link may help
--
http://mail.python.org/mailman/listinfo/python-list
