how to store and still search special characters in Python and MySql

[Justin Ezequiel]

On Feb 12, 12:26 pm, "ronrsr" <ron... at gmail.com> 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