I don't know why it happens.
it works correctly in text or textarea input for me.
Do you have text input and textarea in the same file?
Regards, David.
On Sep 3, 10:31 am, ramazan özdemir <[EMAIL PROTECTED]> wrote:
> i have the same problem.
> i have been done this ( $instDB->executequery("SET NAMES 'utf8'",
> $con); );
> i solve the my problem 50%;it means that data's which are in text
> fields were saved correctly but in textarea were not saved correctly.
>
> On 20 Ağustos, 22:09, David Garcia Ortega <[EMAIL PROTECTED]>
> wrote:
>
> > Hi barophobia,
>
> > I had the same problems as you. I am using special spanish characters
> > as '?', '?' and so on.
>
> > What I did to solve the problems was:
>
> > 1. In MySQL database, establish the collation as 'utf8_spanish2_ci'.
> > To japanese characters you can use 'utf8_unicode_ci'.
>
> > 2. When you load an html page using .load jquery function. For
> > example:
>
> > $('#op_co_wrap').load('html/encuesta/editar_encuesta.html',
> > function()
> > ....
>
> > You have to ensure that the format of 'html/encuesta/
> > editar_encuesta.html' file is utf-8. To do this, I am using notepad++
> > free program:http://notepad-plus.sourceforge.net/es/site.htm. What
> > you have to do is to open the html file with notepadd++ and go to
> > Format-->Codify in UTF-8.
>
> > 3. I am using PHP as web server language. I think you too. Well, if
> > you want to insert, update, .... registers with japanese utf-8
> > characters what you should do in your php script is something like:
>
> > $instDB = new cDB();
> > $con = $instDB->connect();
> > $instDB->executequery("SET NAMES 'utf8'", $con); //IMPORTANT!!!!!!
> > $instDB->executequery("INSERT INTO respuestas (id_encuesta,
> > respuesta, veces_elegida)
> >
> > VALUES ('".$_POST['id_encuesta']."', '".
> > $_POST['a_nom_respuestas'][$i]."', '0')", $con);
> > .......
>
> > executequery code is:
> > function executequery ($consult, $id)
> > {
> > return mysql_query($consult,$id);
> > }
>
> > I think there is anything left.
>
> > I hope it will help you.
>
> > David.
>
> > On 20 ago, 19:11, barophobia <[EMAIL PROTECTED]> wrote:
>
> > > On 8/20/07, Bil Corry <[EMAIL PROTECTED]> wrote:
>
> > > > barophobia wrote on 8/20/2007 11:58 AM:
> > > > > 1. Why do you think the standard pages work fine?
>
> > > > Do you have a meta tag defining the charset? Most likely that wouldn't
> > > > be present in an AJAX call but would tell the browser the correct
> > > > charset.
>
> > > You're right about that. I have:
>
> > > <meta http-equiv="content-type" content="text/html; charset=UTF-8"/>
>
> > > > > 2. What about the issue I'm having sending the data? How do I get the
> > > > > UTF-8 text to be recorded properly when submitted via an AJAX call?
>
> > > > I believe jQuery sends the data as UTF-8; the issue as I understand it
> > > > is when you want to send something other than UTF-8, as per this thread:
>
> > > >
> > > > <http://groups.google.com/group/jquery-en/browse_thread/thread/5fc0bd4...>
>
> > > > You said you're using Japanese characters, are you sure you're using
> > > > UTF-8 or could you be using SHIFT_JIS? Do you have an example page?
>
> > > Actually I'm using UTF-8 for that exact reason. This application will
> > > be (at some point) translated into as many languages as I can get.
>
> > > Based on your information I think my problems will be solved once I
> > > get the server to serve PHP as UTF-8 (I think I can do this via
> > > .htaccess).
>
> > > Thanks for your help with this!
> > > Ch ris.- Alıntıyı gizle -
>
> > - Alıntıyı göster -
