CodeIgniter Forums

Full Version: Mysql/accents problem
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

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

El Forum

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

El Forum

[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

El Forum

[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