SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Wizard
    Join Date
    Jan 2005
    Location
    blahblahblah
    Posts
    1,447
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Setting problem? "" becomes "é" in mysql.

    hi,
    i really have a strange problem. i have a form. when the form is submitted, the data is inserted in the db. the strange thing is that, in mysql, letters like , , are translated into stuff like that: é è.

    I don't do anything that could change the letters before inserting them in the db.

    does anyone have the slightest idea of what's happening?

  2. #2
    SitePoint Wizard
    Join Date
    Jan 2005
    Location
    blahblahblah
    Posts
    1,447
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Here is the exact change:

    '

    becomes (in the same order)

    é è ü ö ä ' �

    I am viewing the field using phpmyadmin. The letters are displayed exactly like that.

    The strangest thing that I just noticed is that if I display the field in a <textarea>, all theletters are displayed as expected.

    I am kinda lost, as you can guess...

    Don't feel that you have to provide an exact answer to this. Don't hesitate to give advice etc...

    thanks

  3. #3
    Non-Member Icheb's Avatar
    Join Date
    Mar 2003
    Location
    Germany
    Posts
    1,474
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Afaik it has to do with the charset that is being used. It doesn't really matter how it's being displayed in phpMyAdmin as long as it's ok for the webinterface of your site, right?

  4. #4
    SitePoint Wizard
    Join Date
    Jan 2005
    Location
    blahblahblah
    Posts
    1,447
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Actually it's displayed in avery funky way everywhere. But I have finally identified the problem.

    It was tough though...

    The problem has to do with the doctype... If one is added, the chars get all funky...

    I will try to ask my question in the proper forum. Sorry to have bothered you guys.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •