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