[V4RB] Encoding-Problem Local vs. Server

[Karl Grob]

I found the solution in a earlier Mail: 
Valentina.InitClient() is not enough, Valentina has to be locally initted.
I consider this as a bug (at least following the manual).

As for UTF-8, it is really very buggy:

Sub speichereWort(vonRid as Integer, wort as string)
	dim myRid as Integer
	if fldOriginalwort.ValueExists(wort) then 
		myRid = fldOriginalwort.FindSingleValue(wort) 
	else
		SetBlank
		fldOriginalwort.Value = wort
		myRid = AddRecord 
	end if
	lnkZuWoertern.LinkRecords(myRid, vonRid) 
End Sub

This routine is able to produce (after "end if") myRid = 0 and this should be logically impossible (no Exception within the if-Statement!).

Everything related to sorting (and of course indexing) goes wrong with UTF-8, so my DB always was in UTF-16. BTW: The language is german, maybe it works in english.

Thanks anyway
Karl

Am 17.01.2010 um 10:50 schrieb Ivan Smahin:

> Hello Karl,
> 
> Sunday, January 17, 2010, 6:20:01 AM, you wrote:
> 
>> First: Thanks for the tip to: [V4RB]OpenDB(classesWay) in Server. It worked.
> 
>> Hi all
> 
>> The first output shown below comes from a local Database, the
>> second one from exactly the same DB on the Server. Everthing is
>> identical except the call of the database and everthing runs on Snow
>> Leopard. Program on a MacPro, Server on a MacMini. Of course both on Intel.
> 
>> VStudio (on the MacPro) gives the correct values(!), 
>> Windows gives a empty char and 
>> If there is a Umlaut (äöü etc.) Ubuntu does not show the line but
>> shows '&' for '…' (Tested on Parallels-Systems).
> 
>> The URL is karlgrob.ch or 192.168.0.x. The string from the cursor
>> (value of StringField) shows the encoding UTF-8. The whole thing on RealBasic 2009r5.
> 
>> Does anyone know how I earned that? 
> 
> Please check - do you have UTF8 as "Storage Encoding"?
> Actually  it  is  still  buggy  and  you  should not use it. Set UTF16
> instead (default state).
> 
> 
> 
> 
> -- 
> Best regards,
> Ivan Smahin 
> Senior Software Engineer
> Paradigma Software, Inc
> Valentina - The Ultra-Fast Database
> http://www.valentina-db.com
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macserve.net/pipermail/valentina/attachments/20100117/e5f34f2a/attachment.html