#50 0.71 Character Encoding

[timothy]

Hi,

I just tested 0.71 with Windows

First you already know about the 1.0 vs 1.1 bug,
for the time being we can compile against 1.0
and force it to run against 1.1 (The application which
uses the driver I mean)

Anyway I wrote some lines of code
which take all the files on a HD and
put them in a database

Below is part of the output
(Don't mind the XML, that's because I took a snapshot
with QuickSQL, WebMin shows the same results)

<?xml version="1.0" standalone="yes" ?>
- <NewDataSet>
- <core>
<file>c:oot.ini</file>
</core>
- <core>
<file>c: tldr</file>
</core>
- <core>
<file>c:AUTOEXEC.BAT</file>
</core>
- <core>
<file>c:AVG6DB_F.DAT</file>
</core>
- <core>
<file>c:Bootfont.bin</file>
</core>
- <core>
<file>c:CONFIG.SYS</file>
</core>
- <core>
<file>c:CygWininasename.exe</file>
</core>
- <core>
<file>c:CygWininash.exe</file>
</core>
- <core>
<file>c:CygWininashbug</file>
</core>

As you can see characters aren't correctly encoded
and the \ is even left out completely

Thnx
Tim.

[timothy]

Logged In: YES
user_id=332963

Update: Using the same assembly on Linux - Works fine

83 | /bin/touch |
| 84 | /bin/true |
| 85 | /bin/umount |
| 86 | /bin/uname |
| 87 | /bin/unicode_start |
| 88 | /bin/unicode_stop |
| 89 | /bin/unlink |
| 90 | /bin/usleep |
| 91 | /bin/vi |
| 92 | /bin/view |
| 93 | /bin/ypdomainname |
| 94 | /bin/zcat |
| 95 | /boot/boot.b |
| 96 | /boot/chain.b |
| 97 | /boot/config-2.4.20-18.9 |
| 98 | /boot/config-2.4.20-8 |
| 99 | /boot/initrd-2.4.20-18.9.img |
| 100 | /boot/initrd-2.4.20-18.9-TP.img

Hope this helps

[Reggie Burnett]

Logged In: YES
user_id=523261

what language encoding are you using on the Mysql server?
Using Latin1 on my server, the driver works exactly like the
mysql command line client.

[timothy]

Logged In: YES
user_id=332963

The server uses Latin1 I guess (Belgian)

- When using your driver with mono on linux it works fine
- When using your driver with .NET on windows it encodes wrong
- Haven't tried using your driver with mono on windows, but
I will when I get back.

I added 1.000.000 records to the MySQL database yesterday,
using your driver from linux, all entries are ok.

So the problem is either on windows or .NET

Tim.