realbasic-nug
[Top] [All Lists]

Re: Encoding in databases

To: REALbasic Network Users Group <realbasic-nug at lists dot realsoftware dot com>
Subject: Re: Encoding in databases
From: Matthias Buercher <reader at belle-nuit dot com>
Date: Mon, 31 Mar 2003 00:55:51 +0200

On Sunday, Mar 30, 2003, at 23:04 Europe/Zurich, Olivier Scherler wrote:

rb doesn't know the encoding when you read from the database.
when you read a database cursor, define its encoding as UTF8 before you
hand it to the editfield.

How do I do that? There are no properties or methods related to encoding in
DatabaseCursor, RecordSet, REALDatabase or Database.
Moreover, since the DataControl is (autonotsomagically) handing the data to the EditField, I have no control over the process, unless I write a class that duplicates DataControl's behaviour*. Being used to C++, Java and Objective C,
I'd subclass DataControl, but since there's no ReadFormDB- or
PopulateFields-like methods to override, I have the hands tied in the back.

i agree that you cannot do that directly and this creates problems for RB-techniques like datacontrol and control-binding which are obsolete in this context. you have to read the database to strings and then manually populate the listboxes and editfields.

Furthermore, considering RB wrote the database, I would expect it to be able to
read back from it without me having to tell it how it encoded data. I'd
understand having to be careful with an external database like mySQL, but in no way should it require manual conversion. A property should be set, period.

file a bug report.

matthias

---------------------------------------------------------
Matthias Buercher matti at belle-nuit dot com www.belle-nuit.com
---------------------------------------------------------
war in iraq - not in my name
http://www.gssa.ch/antiguerre/
http://www.unitedforpeace.org


---
A searchable archive of this list is available at:
<http://support.realsoftware.com/listarchives/search.php>

Unsubscribe:
<mailto:realbasic-nug-off at lists dot realsoftware dot com>

Subscribe to the digest: <mailto:realbasic-nug-digest at lists dot realsoftware dot com>
.


<Prev in Thread] Current Thread [Next in Thread>