[OGo-Bugs][Bug 1958] Encoding conversion from text stored in db

[bugs@opengroupware.org]

Please do not reply directly to this email. All additional
comments should be made in the comments box of this bug
report.

http://bugzilla.opengroupware.org/bugzilla/show_bug.cgi?id=1958





------- Additional Comments From henrik@holmboe.se  2008-03-02 15:32 -------
>From Bugzilla Helper:
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.12) Gecko/20080207
Ubuntu/7.10 (gutsy) Firefox/2.0.0.12

Description of problem:
I am running two versions of OGo, one old 1.0 and one 1.1 (see comment #1 in bug
#1957). Both installations are connecting the same database.

In version 1.0 it's possible to search for a single swedish character in
Companies and for example return all companies with the letter "å" in them. In
version 1.1 the same search returns no hits.

If I pull up the same entry in Companies some encoding conversion is not done
correctly. In version 1.0:

 Reklambyrå AB

In version 1.1:

 ReklambyrÁB

The same problem occurs not only in the company name but also in Comments inside
a Contact.

The database is running encoding SQL_ASCII. Is it recommended to use UTF8 the
database for OGo version 1.1?

Version-Release number of selected component (if applicable):


How reproducible:
Always

Steps to Reproduce:
1. Search for other characters than a-zA-Z.


Additional info:

------- You are receiving this mail because: -------
You are on the CC list for the bug, or are watching someone who is.