Re: [fw-mvc] Problem: Turkish Characters can not be saved to database

We're always looking for translations so you can let me know. The HTML and PDF are generated from one set of files. The PDF will be available sometime next year before the Summer - since it's a free book we can afford to take our time moving it along ;).

 

Pádraic Brady

http://blog.astrumfutura.com
http://www.survivethedeepend.com
OpenID Europe Foundation Irish Representative

---

From: Erdal YAZICIOGLU <erdal.yazicioglu@gmail.com>
To: Pádraic Brady <padraic.brady@yahoo.com>
Cc: Zend Framework MVC <fw-mvc@lists.zend.com>
Sent: Wed, December 23, 2009 11:18:21 AM
Subject: Re: [fw-mvc] Problem: Turkish Characters can not be saved to database

Hello Padraic,

Thanks for the info. I will give it a try and let you know. For now I leave the code as it is. As soon as I start clear up the application, I will take a look. I put it in my task list.

By the way, when are you going to publish survivingthedeep in pdf? I can not wait to translate it in Turkish:)

Regards and merry christmas.
E

2009/12/23 Pádraic Brady <padraic.brady@yahoo.com>

That function should have read mb_strtolower() ;)

 

Pádraic Brady

http://blog.astrumfutura.com
http://www.survivethedeepend.com
OpenID Europe Foundation Irish Representative

---

From: Pádraic Brady <padraic.brady@yahoo.com>
To: "erdal.yazicioglu@gmail.com" <erdal.yazicioglu@gmail.com>
Cc: "fw-mvc@lists.zend.com" <fw-mvc@lists.zend.com>
Sent: Wed, December 23, 2009 7:41:12 AM
Subject: Re: [fw-mvc] Problem: Turkish Characters can not be saved to database

Try using a unicode safe method for lowercasing like iconv_strtolower. The base function is only useful for US ASCII.

Paddy

Sent from my iPhone

On 22 Dec 2009, at 12:43, Erdal YAZICIOGLU <erdal.yazicioglu@gmail.com> wrote:

Hello all

I have a really very strange problem withthe Turkish characters.

I have a form where alumni registers itself. I am trying to convert all
data to lowercase and then write to database.

In the model I create a function

public function toLowerCase($input)
  {   
  return strtolower(strtr($input,'ĞÜŞIİÖÇ','ğüşıiöç'));
  }

After a successful admission I write the data to database in model as
follows.

function registerAlumni($alumniName,$alumniLastName,$alumniGraduateDate)
  {
      $data = array('alumni_Name'=>$this->toLowerCase($alumniName),
                  'alumni_LastName'=>$this->toLowerCase($alumniLastName),
                  'alumni_GraduateDate'=>$alumniGraduateDate);
      $this->insert($data);
  }

Up to here everything seems to be OK. But when I run the database query,
the characters that are entered in turkish are not written into
database.

I really do not know, if it is Zend or Mysql itself. I use UTF-8 as
character encoding and if I do not use toLowerCase method, it writes to
database without problem.

Any ideas are more than welcome.

E

mysql> select alumni_Name,alumni_LastName,alumni_GraduateDate from
gbhl_alumni order by alumni_ID desc
  -> ;
+---------------------+-----------------+---------------------+
| alumni_Name        | alumni_LastName | alumni_GraduateDate |
+---------------------+-----------------+---------------------+
|                    | mmmmmmmmmmm    |                1991 |
|                    | mmmmmmmmmmm    |                1991 |
|                    | mmmmmmmmmmm    |                1991 |
|                    | mmmmmmmmmmm    |                1991 |
|                    | mmmmmmmmmmm    |                1991 |
|                    | mmmmmmmmmmm    |                1991 |
|                    | mmmmmmmmmmm    |                1991 |
| mmmmmmmmmmmmmmmm    | mmmmmmmmmmm    |                1991 |
|                    |                |                1991 |
|                    |                |                1991 |

--

Erdal YAZICIOGLU
Field Project Engineer Manager
Page Europa S.R.L - General Dynamics
www.pageuropa.it
Office - Rome : +39 0650395292
Mobile -Rome : +39 3490787196
Mobile -Istanbul: +90 536 3447989