[ADMIN] index not used in ( varchar = text )

2003-02-22 Thread Gaetano Mendola
Hi all, why in Postgresql 7.3.2 in a select like: SELECT * FROM user_login WHERE login = 'FOO'::text; and login is a VARCHAR the index on login is not used anymore ? Ciao Gaetano ---(end of broadcast)--- TIP 6: Have you searched our list arch

Re: [ADMIN] problem: Postgresql and Unicode

2003-02-22 Thread Björn Metzdorf
> But now I'm facing another problem: > How do I convert existing data in an SQL_ASCII database to unicode? > > Has anyone tried this before? Yes, that is no problem. Have a look at http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=multibyte.ht ml#AEN21920 short: dump sql_ascii, cre

Re: [ADMIN] problem: Postgresql and Unicode

2003-02-22 Thread Nathalie Boulos
Hi Arthur , Thank you very much for your reply. It was indeed a PHP problem. I just set the default_charset variable in php.ini to utf-8 and it worked. But now I'm facing another problem: How do I convert existing data in an SQL_ASCII database to unicode? here's my problem: I have a SQL_ASCII