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 -
