CodeIgniter Forums
Mysql/accents problem - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Mysql/accents problem (/showthread.php?tid=11000)

Mysql/accents problem - El Forum - 08-21-2008

[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!

Mysql/accents problem - El Forum - 08-21-2008

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

Mysql/accents problem - El Forum - 08-21-2008

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

Change:
Code:
<html>

with:

Code:
<? header('Content-Type: text/html; Charset=UTF-8');  ?>
<html lang="es">

Thanks all
Edgar Nadal

Mysql/accents problem - El Forum - 03-11-2010

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

Change:
Code:
<html>

with:

Code:
<? header('Content-Type: text/html; Charset=UTF-8');  ?>
<html lang="es">

Thanks all
Edgar Nadal[/quote]

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