realbasic-nug
[Top] [All Lists]

Encoding in databases

To: REALbasic Network Users Group <realbasic-nug at lists dot realsoftware dot com>
Subject: Encoding in databases
From: Olivier Scherler <olivier at aloah dot net>
Date: Sun, 30 Mar 2003 15:15:51 +0200
Hi all,

I'm renew to this list, having used RB 3 and considering buying version 5 Pro.

I'm testing the database features of RB. I have a REALDatabase with a simple
table with ID, Name and FirstName and I use a DataControl to browse and edit it,
the standard tutorial way. However, when I create a new record with 8-bit
characters in a field, I get terrible results. Example:

- I enter "Gérard Lambert", click Insert (Object bound to Insert in the
DataControl)
- I get "G?©rard Lambert", typical MacRoman misrepresentation of UTF-8 data.
- If I browse the records, the next time I get "G?àö¬©rard Lambert", less
typical MacRoman misrepresentation of the MacRoman misrepresentation of UTF-8
data.
- And so on:
"G?Äö?Ñ???àö?ë?àö?àÇ?Äö?Ý???àö?´?Äö?Ý???Äö?Ý?á?Äö?Ñ???àö?ÄÝ?àö?àÇ?Äö?Ñ???àö?ë?Äö
?Ñ?ÄÝ?Äö?Ñ???àö?ÄÝ?àö?àÇ?Äö?Ñ???àö?ÄÝ?àö?°¬¨¬®¬¨¬Æ¬¨¬®¬¨?ܬ¨¬®¬¨¬Æ¬¨¬®¬¨¬©rard
Lambert" after a while.

What should I do? I tried using a TextConverter in the Validate event of the
DataControl when inserting records, but I get worst results. And it seems the
problem is not at the insertion (RB converts MacRoman to UTF-8) but at the
retrieval.

Anyway, I don't understand why RB woudn't work out of the box with 8-bit data.
After all, I work in French, not in Chinese.

Olivier

---
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>