Re: [Phpgedview-talk] ERROR:-1 DB Error: unknown error

[Mario G. <mar...@ti...>]

Il 22/04/2009 11.24, Eric D'Mellow ha avuto l'onore e l'ardire di scrivere:
> Hello Everybody,
Hello Eric and everybody,
This is my first post here.
I'm an italian young man and I write english a little... I'm sorry for
mistakes on my english!!

> 
> I recently decided to reinstall PGV 4.2.1 (I had 4.2.0 working properly)
> from the very beginning. I wanted to use UTF-8 collation in order to speed
> up the database.
> 
>  
> 
> Everything in the new installation seems to be working properly except for
> when I go to the individual of family listings I receive the following error
> message:
> 
>  
> 
> ERROR:-1 DB Error: unknown error
> 
> SQL:SELECT SUBSTR(n_sort COLLATE utf8_unicode_ci, 1, 1) AS alpha FROM
> pgv_name, pgv_individuals WHERE n_file=1 AND i_file=n_file AND i_id=n_id
> GROUP BY 1 ORDER BY 1 [nativecode=1253 ** COLLATION 'utf8_unicode_ci' is not
> valid for CHARACTER SET 'latin1']
> 

I fix the trouble wrote by Eric some days ago, when I try to reinstall
my PhpGedView site.

I set true the variable $DB_UTF8_COLLATION on config.php.
I fix setting $DB_UTF8_COLLATION=false

I hope this will resolve yuor truoble.

Best regards,
Mario

-- 
MARIO GOLFETTO
mariogolf[DOT]web[AT]tiscali[DOT]it