Message-ID:

An Ada exception is when a routine gets in trouble and says 'Beam me up, Scotty'.

devel / comp.lang.clipper.visual-objects / Updating SQLSelect from MemoField (or MultiLineEdit)

Updating SQLSelect from MemoField (or MultiLineEdit)

<5fae4252-c5c3-40bb-9130-15d4b257690fn@googlegroups.com>

https://www.rocksolidbbs.com/devel/article-flat.php?id=898&group=comp.lang.clipper.visual-objects#898

copy link Newsgroups: comp.lang.clipper.visual-objects

X-Received: by 2002:a05:6214:300c:: with SMTP id ke12mr27097547qvb.38.1627469545436;
Wed, 28 Jul 2021 03:52:25 -0700 (PDT)
X-Received: by 2002:a05:620a:5f6:: with SMTP id z22mr26431910qkg.195.1627469545275;
Wed, 28 Jul 2021 03:52:25 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.clipper.visual-objects
Date: Wed, 28 Jul 2021 03:52:24 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=87.102.215.94; posting-account=FsGVgwoAAAAo88J9fd3ig_ravrDh6B2l
NNTP-Posting-Host: 87.102.215.94
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <5fae4252-c5c3-40bb-9130-15d4b257690fn@googlegroups.com>
Subject: Updating SQLSelect from MemoField (or MultiLineEdit)
From: zodcomag@gmail.com (Henry Fidler)
Injection-Date: Wed, 28 Jul 2021 10:52:25 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

by: Henry Fidler - Wed, 28 Jul 2021 10:52 UTC

The MySQL has a collation of utf8_general_ci, so when I try to update, for example "ü", from my local dbf fields, I use
C1 := Ansi2UTF8("ü") // returns Ã¼
and with this c1 I am updating the MySQL host.
It does work OK.

BUT
When I am retrieving the value from a MemoField (or from a MultiLineEdit), the Ã¼ is updated usually, but in the moment I
Update(True) or Commit()
the MySQL values are loosing the Ansi2UTF8, and the original, wrong, values are committed.

Why does it work OK with normal fields, but not with data retrieved from Memo field or from MuiltiLineEdit?
Is there a workaround?

Thanks
Henry

Subject	Author
Updating SQLSelect from MemoField (or MultiLineEdit)	Henry Fidler