How do I get Baltic characters saved in database and in e-mail

1

Clarion 10, NetTalk 9.3

I have a requirement for Baltic characters in e-mails. I played a little with charset (ISO-8859-1) and used HTML, tried system{Prop:Charset}=CharSet:Baltic
At first glance it looked correct. However, the characters are changed. ANSI?
This
ą, č, ę, ė, į, š, ų, ū, ž, Ą, Č, Ę, Ė, Į, Š, Ų, Ū, Ž.
becomes
a, c, e, e, i, š, u, u, ž, A, C, E, E, I, Š, U, U, Ž.

Most are distored.

Upon closed investigation, the distortion happens somewhere when assigning. It will be saved distorted and if I save it directly in database, it is distorted on screen when read back.

So, how do I make my program support Baltic?

2

Hi, the charset should be cp1257 (Windows1257)
In case of HTML it`s better to use UTF-8 but that depends on the DB you are using and the application.

3

I can’t find that charset. Can you tell me where I can find cp1257 and how to set it im this.context?

4

What database are you storing the data in?

5

It is MSSQL. The conversion happens when assigning string to string, or something like that, because it happens with strings before they are saved and when they are retrieved.

I think I have solved it now though.
Withing regional settings, there is a link to “Administrative settings” (or something like that). This leads to an “Area” setting, where I can set “Language for non-Unicode programs”. This I set to Lithuanian. When this is done, and computer restarted, I can write and read from database without distortion.
For pure text e-mails, the strings now works with ISO-8859-13.
For html, there are still too many wrong characters, so I do a search and replace for character to HTML equivalent.

6

Yes, this was the thing I was going to point you to. Non-unicode apps, which Clarion ones obviously are, use the OS default codepage (which differs depending on your location).
This setting will change the OS default codepage to the codepage of your choice, the assumption being that you’ve already checked that the codepage you pick contains all the characters you want.
MS has a whole website devoted to globalisation & internationalisation, but a lot of it assumes you’re using unicode and we aren’t there yet.

7

Think looked so good, but now my norwegian charaters are distored.
If I set 0{prop:fontcharset = CharSet:Baltic, they look OK, but it seems that this has negative impact on lists.