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

Discussion in 'Python' started by ronrsr, Feb 12, 2007.

  1. ronrsr

    ronrsr Guest

    I have an MySQL database called zingers. The structure is:

    zid - integer, key, autoincrement
    keyword - varchar
    citation - text
    quotation - text

    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
    special problem, even though I have ''ed all 's

    perhaps the encoding of the database itself should be different? it
    currenlty latin_swedish_ci

    Input and output is through a browser.

    I think my problem may be that I need to encode the string before
    saving it in the databse. Can anyone point me in the right direction

    here's the error message:

    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
    in range(128)')
    encoding = 'ascii'
    end = 96
    object = "update zingers set keywords = 'a;Action;b;Religi...
    \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.

    Can anyone help me on this?


    ronrsr, Feb 12, 2007
    1. Advertisements

  2. <snip>

    as nobody has replied yet...perhaps the above link may help
    Justin Ezequiel, Feb 15, 2007
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.