Okey, thanks.
Is it also possible to do this using a config.ini file?
Stefan Gehrig wrote:
Hi Anders,
you can use the following to create the adapter if you're using the
PDO-adapters:
$db=Zend_Db::factory('Pdo_Mysql', array(
'host' => 'localhost',
'username' => 'user',
'password' => 'pa$$w0rd',
'dbname' => 'database',
'driver_options' => array(
PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'
)
));
This ensures that the SET-NAMES-Command is issued with every reconnect of
the underlying adapter.
Best regards
Stefan
-----Ursprüngliche Nachricht-----
Von: Anders Gunnarsson [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 27. Juni 2008 09:10
An: [email protected]
Betreff: Re: [fw-general] Re: sql lower encoding
The encoding problems ended when setting
$this->query('SET NAMES utf8');
at both insert and select.
Is there a better way to do this? At db-connection time?
Johannes Schill wrote:
If you're inserting with a form, you can always try adding
accept-charset="UTF-8" on your form-tag.
Johannes
2008/6/26, Anders Gunnarsson <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>>:
I found out that my problem must be on inserting.
How can I be sure that I'm inserting with utf8?
If I insert ÅÄÖ in phpmyadmin, they are inserted correctly,
but not when inserting from my own forms.
I've tried
$this->query('SET NAMES utf8');
before inserting, but it doesn't seem to help.
can I use config.ini to specify utf8?
and would that help?
regards
Anders
Anders Gunnarsson wrote:
Hi!
I'm doing a SQL LIKE() with non-western characters.
SELECT * FROM users WHERE LOWER(userName) LIKE '%'.
mb_strtolower($searchStr, mb_detect_encoding($searchStr)) .'%'
The php is converting the characters right,
but the SQL isn't.
I'm using mysql 5.0.38
and utf8_unicode_ci
Maybe somebody has an other sollution to searching
case-insensitive with non-western characters?
