Accented character problem from Mac OS to Windows

[Ruslan Zasukhin]

On 11/4/04 2:49 PM, "Leo Van den Brande" <leo_van_den_brande at wxs.nl> wrote:

Hi Leo,

> Hi Ruslan,
> 
> I have now fully implemented Valentina in my program (RealBasic 5.2.4),
> that supports authors when making a multimedial clinical textbook. It
> works like a charm!
> 
> Except, I encounter an unexpected problem with accented characters on
> transfer of the DB between platforms that I can't solve. I could not
> find the answer to this specific problem in the Valentina discussions,
> so, I must bother you again.
> 
> I store text as is and on retrieval define UTF8 as encoding.

You store text into Valentina UTF8 ?!
I think this is source of problem then.

> When text is stored and retrieved under Mac OS, accented characters come
> out right. However, when copying this DB to a Windows platform (2000 and
> XP) and retrieve the text, accented characters are simply lost (in
> Dutch: "patiënt" becomes "patint"). If next, still under Windows, I
> correct this in the editor back to "patiënt", store in the same DB and
> retrieve, the accented character is there as it should be.
> 
> Since some authors work under the Mac OS and others under Windows and
> must exchange DB's, this poses a problem. What should I do?

Valentina 1.x do SELF conversion of text which is stored in String, VarChar
or Text field.

And I think this is why you see your problem.

Valentina expect that on Mac text is in the Mac Western encoding,
And on Windows it is in Latin-1 encoding.
When file are moved Valentina self do conversion between these encodings.

You try to do UNUSUAL thing.

I think you need simply to store encodings as I have point.


> Thanks very much!
> 
> Kindly,
> 
> Leo

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------