Login

08-21-2008, 12:10 PM

[eluser]Unknown[/eluser]
Hello,

I have a problem with mysql and the accents if i write a sql query with accents like

Code:
INSERT INTO 'xxx' VALUES('óíúíñÑ')

in the database write '??????' what can i do!!??

Thanks!

08-21-2008, 12:37 PM

[eluser]cmgmyr[/eluser]
Looks like you will have to change the collation of your database/table. Try using: utf8_general_ci

08-21-2008, 12:52 PM

[eluser]Unknown[/eluser]
Thanks, i found the solution:

Change:

Code:
&lt;html&gt;

with:

Code:
&lt;? header('Content-Type: text/html; Charset=UTF-8');  ?&gt;

&lt;html lang="es"&gt;

Thanks all
Edgar Nadal

03-11-2010, 04:36 PM

[eluser]Juan Velandia[/eluser]
[quote author="EdgarN" date="1219362759"]Thanks, i found the solution:

Change:

Code:
&lt;html&gt;

with:

Code:
&lt;? header('Content-Type: text/html; Charset=UTF-8');  ?&gt;

&lt;html lang="es"&gt;

Thanks all
Edgar Nadal[/quote]

Hello Edgard, wich file should I work on to make this change? thanks