Hi!

We're having problems with Scandinavian characters in OI 4.1/4.11

All our characters like A with dots and O with dots (for example Alt+0196 and Alt+0214). Is there any fix that can correct this or do I have to manually change this? Or is there any other way?

/Bertil

Bertil,

Seems neither Revelation nor the beta testers checked how the Unicode-enabled OI would work with existing apps that already contain foreign characters. There's a fix in the pipeline. But unfortunately there's not been much info on the discussion lists.

- Oystein -

Is the fix in Revelations pipeline? When is it going to be released?

/Bertil

Bertil,

The problem (your problem, my problem) is that the system assumes all rows (windows, popups, stored procedures, data rows, etc) are UTF8 encoded, while in reality they are ANSI encoded. (Or to be more precise our rows are encoded according to Microsoft's WinLatin-1 character set.) UTF8 and ANSI have the 7-bit characters in common, so in an English-language app there might not be any difference between a UTF8 and an ANSI version of the row. But once characters like our funny Scandinavian ÆØÅÖÄæøåöä letters occur OI 4.1 assumes they are the first byte in multi-byte UTF8 characters.

In OI 4.1 there is a function ANSI_UTF8 that can convert a row coded in ANSI to a row coded in UTF8. I have tried to convert a few app and data rows with ANSI_UTF8 and it seems to work OK. Except the first version(s) of that function had serious faults, so you better download a late 4.1, where the bugs are supposed to be fixed. But as far as I know there is no tool that can automatically convert all your app and data.

- Oystein -

Bertil,

In the 4.1.1 version there is a /ANSI command line switch, causing it to behave exactly as it in 4.0 with regards to how characters are used.

Pat

View this thread on the Works forum...