Encoding of 1-2 converted db

jda jda at his.com
Fri Oct 14 09:13:31 CDT 2005


>After conversion of a database from Val 1 to 2 I experience an 
>encoding problem.
>
>I develop on Mac OS 10.2.6 with Realbasic 5.5.2.
>
>With Val 1, I applied conversion to MacRoman for Mac and 
>WindowsLatin1 for Windows, both on storage and retrieval. This 
>worked well.
>
>According to the documentation and discussions, Val2 delivers UTF8 
>format which is Realbasic format.
>
>So, I queried with:
>c  = App.mValdb1.SQLSelect(s,EVCursorLocation.kServerSide, 
>EVLockType.kReadOnly, EVCursorDirection.kRandom)
>
>and retrieved a string with:
>aResult = c.Field(<some field name>).GetString
>
>Accented characters do not show correctly in RB on Mac.

I filed a bug report on this a long time ago (can't find it on Mantis 
right now). Ruslan says that's because V2 doesn't know the encoding 
of the source 1.x db. I pointed out that if the specified language is 
a Roman one (like English) the encoding will be MacRoman on a Mac, 
and so the conversion should work. That was the end of it. I think 
all conversion-related issues have been tabled...

Jon


More information about the Valentina mailing list