In fact I can't explain it to me.
I made a new rb db and a simple db editor to insert data into.
The project is made of a window with a datacontrol and 2 editfield (id and
text field of the database); there are also 3 pushbuttons (insert, update
and delete). Data are stored correctly.
In the same window I put a listbox (3 coloumns: rowid, id, text) and a
databasequery to view all the record with a button to requery.
So I can see the same database data retrived by datacontrol and
databasequery.
Record 1:
Datacontrol: id:1 text:à
databasequery: id:1 text:?Ý
Record 2:
Datacontrol: id:1 text:è
databasequery: id:1 text:?®
Record 3:
Datacontrol: id:1 text:é
databasequery: id:1 text:?©
Record 4:
Datacontrol: id:1 text:ì
databasequery: id:1 text:?¨
Record 5:
Datacontrol: id:1 text:ò
databasequery: id:1 text:?¾
Record 6:
Datacontrol: id:1 text:ù
databasequery: id:1 text:?¼
If you want I can send you project and db (45kb total).
Thanks
Best regards
Fabio Soggia
> From: "Joseph J. Strout" <joe at realsoftware dot com>
> Reply-To: Getting Started <gettingstarted at lists dot realsoftware dot com>
> Date: Sat, 28 Aug 2004 20:43:24 -0500
> To: Getting Started <gettingstarted at lists dot realsoftware dot com>
> Subject: Re: Encoding problem?
>
> At 7:40 PM +0200 8/28/04, Fabio Soggia wrote:
>
>> I suppose it is an encoding problem.
>> I tried:
>>
>> EditField1.Text = ConvertEncoding(Listbox1.Cell(row, 2), Encodings.UTF8)
>>
>> And
>>
>> EditField1.Text = ConvertEncoding(Listbox1.Cell(row, 2),
>> Encodings.WindowsANSI)
>
> You should use:
>
> EditField1.Text = Listbox1.Cell(row, 2)
>
> In other words, there is no point in converting the text at this
> point. If there is a problem, it must be earlier in the process.
> But the new REAL Database engine handles encodings correctly, as long
> as the text encoding is defined correctly when it goes in. So I
> think you need to back up and tell us where this text you're storing
> has come from.
>
> Best,
> - Joe
>
> --
> ,------------------------------------------------------------------.
> | Joseph J. Strout REAL Software, Inc. |
> | joe at realsoftware dot com http://www.realsoftware.com |
> `------------------------------------------------------------------'
> _______________________________________________
> Unsubscribe or switch delivery mode:
> <http://www.realsoftware.com/support/listmanager/>
>
> Search the archives of this list here:
> <http://www.realsoftware.com/listarchives/lists.html>
>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://www.realsoftware.com/listarchives/lists.html>
|