Zend $db->quote not encoding special characters

Question

I'm trying to use Zend's insert with the following string:

Almoço

Whether or not I use zend's quoteInto function, the string is inserted into the database as:

AlmoÃ§o

How do I fix it so that the string I write/read to/from the database is the same as the original string?

What's special in `ç`? Why do you think it should be quoted? — zerkms, Nov 21 '12 at 02:49
i don't think it needs to be quoted. I just tried quoting because it didn't work without quoting. (although I think that *update* quotes the string anyway) — Gil Birman, Nov 21 '12 at 02:51
It would work if you used proper charset connection setting and proper encoding in DB — zerkms, Nov 21 '12 at 02:51
I'm using **latin1_swedish_ci** which is the proper one to use? — Gil Birman, Nov 21 '12 at 02:52

score 1 · Accepted Answer · answered Nov 21 '12 at 03:20

1

You should specify a proper encoding (for db columns and connection) that has ç character in its character set.

In this case it's presumably UTF-8

answered Nov 21 '12 at 03:20

zerkms

1 Answers1