Search problems version 4.5.1b

[gkomnin]

os:windows xp sp2
mysql:4.1.22
php:4.4.2

i upgraded to the version 4.5.1b with success...
in my contacts/leads/accounts i also use greek characters .After the upgrade i cant see the greek characters despite i see some strange characters.
When i add a new contact with greek characters everything is ok...but the existing contacts are not shown well.
I checked the database also and the greek characteers are not displayed...What is happening??>

[gkomnin]

My database before the update had encoding latin but the sugar 451 requires utf 8(i think so)...when i run the update wizard i think that the wizard makes the conversion to utf 8...Am i right?
If not do i have to convert the database to utf8 manually before the update??
And if that how i can do that?

[sugarchris]

when i run the update wizard i think that the wizard makes the conversion to utf 8...Am i right?

Correct.

What version did you upgrade from?

If not do i have to convert the database to utf8 manually before the update??
And if that how i can do that?

If you do not have a backup of your database (you should always have a full backup ready in case the upgrade fails), you will have to manually apply the UTF8 conversion.

This is the template query we use in Sugar:

ALTER TABLE $table CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci

You can write a simple PHP loop to find all tables and insert the table name in the $table variable to run this against all tables. It is safe to run against UTF8 tables too (MySQL should just skip them).

[gkomnin]

i updated from 4.2.0d to 4.2.1 with success and then i upgraded to 451b...
after the upgrade i cant view the greek letters.I see strange characters despite...i do not know what its is..The database and the tables are utf-8(it think so)...What is happening??I am totally confused