Details
-
Type:
Bug
-
Status:
Resolved
-
Priority:
Critical
-
Resolution: Cannot Reproduce
-
Affects Version/s: 1.2.2
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
Environment:windows 7 , bitnami wappstack
Description
Hi,
I'm trying to insert query . But i have a charset problem.
I'm poor speak english, sorry.
my bootstrap code quote:
$conn = Doctrine_Manager::connection($db);
$conn->setCollate('utf8_unicode_ci');
$conn->setCharset('utf8');
controller code:
$user = new YpUser();
$user -> business_name = 'Turcom';
$user -> complete_adress = 'Maslak/Itü';
$user -> contact_person = 'Oguzhan Cetin';
$user -> contact_number = '05065000000';
$user -> save();
///////////////////
Error:
Fatal error: Uncaught exception 'Doctrine_Connection_Pgsql_Exception' with message 'SQLSTATE[22021]: Character not in repertoire: 7 HATA: "UTF8" dil kodlaması için geçersiz bayt dizisi: 0xfc HINT: Bu hata ayrıca bayt sırasının sunucunun beklediÄ� kodlamada olmadıÄ�± zaman meydana gelmektedir. İstemci dil kodlaması "client_encoding" seçeneÄ� ile ayarlanmaktadır.' in C:\LOCAL\stack\apache2\htdocs\pbmp\libraries\doctrine\Doctrine\Connection.php:1082 Stack trace: #0 C:\LOCAL\stack\apache2\htdocs\pbmp\libraries\doctrine\Doctrine\Connection\Statement.php(269): Doctrine_Connection->rethrowException(Object(PDOException), Object(Doctrine_Connection_Statement)) #1 C:\LOCAL\stack\apache2\htdocs\pbmp\libraries\doctrine\Doctrine\Connection.php(1042): Doctrine_Connection_Statement->execute(Array) #2 C:\LOCAL\stack\apache2\htdocs\pbmp\libraries\doctrine\Doctrine\Connection\Pgsql.php(244): Doctrine_Connection->exec('INSERT INTO yp_...', Array) #3 C:\LOCAL\stack\apache2\htdocs\pbmp\libraries\doctrine\Doctrine\Connection\U in C:\LOCAL\stack\apache2\htdocs\pbmp\libraries\doctrine\Doctrine\Connection.php on line 1082
Thanks For help.