• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Error inserting special characters (spanish) into database

#1
[eluser]jorgeakanieves[/eluser]
Bufff...
I´m trying to insert special characters ( accent '´' and question character '¿' ) but the inserted field is null. If I do the query in phpmyadmin directly, it´s inserted all right.

I don´t know whay may be happening because I´ve defined:

database.php:
Code:
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_general_ci";

And with the phpmyadmin client, my database, tables and fields are set to:
database: utf_spanish_ci
table: utf_spanish_ci
field: utf_spanish_ci

In the config file of mysql ( my.ini ):
Code:
[mysql]
default-character-set = utf8_general_ci
[mysqld]
default-character-set = utf8_general_ci
character-set-server = utf8
collation-server = utf8_general_ci
init_connect = 'SET collation_connection = utf8_general_ci'
init_connect = 'SET NAMES utf8_general_ci'

What´s the error?


Messages In This Thread
Error inserting special characters (spanish) into database - by El Forum - 03-12-2009, 03:04 AM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.