View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0036056||FPC||Database||public||2019-09-08 09:27||2019-09-08 12:24|
|Reporter||Alex||Assigned To||Michael Van Canneyt|
|Status||resolved||Resolution||no change required|
|Product Version||3.0.4||Product Build||61665|
|Target Version||Fixed in Version|
|Summary||0036056: UTF8+DBF blobs|
|Description||As an some architector i think it's all around UTF8 and it's char/bytes counting.|
Searching some utf8 text in blobs fails with positioning...
Blobs with dbf still has an issue with view by dbtext.
So also this thing is wet as hell. Blobs is fast blowing up, can't maintain it (pack&other).
|Steps To Reproduce||Search utf8 text in dbmemo.|
Import broken 1,5G dbf base with blobs, add-remove-pack it. ;)
|Tags||No tags attached.|
|Fixed in Revision|
Please provide a program that shows the issue.
With this description, I cannot understand what the *exact* problem is, much less fix it.
When I use it with UTF8pos the relative positions are correct if the blob is indeed an UTF8 text file. (Pos gives absolute positions)
I think the issue is wrong use of Pos.
Actually I think this should be asked on the forum, and the solution is given here: https://forum.lazarus.freepascal.org/index.php/topic,45446.msg321459.html#msg321459
If the problem is what is referenced in the forum post, then the problem is indeed wrong use of Pos.
In Delphi, string equals widestring. In fpc it is not, so the contents is UTF8 and utf8 functions must be used.
|2019-09-08 09:27||Alex||New Issue|
|2019-09-08 09:41||Michael Van Canneyt||Note Added: 0117984|
|2019-09-08 11:43||Thaddy de Koning||Note Added: 0117985|
|2019-09-08 11:44||Thaddy de Koning||Note Edited: 0117985||View Revisions|
|2019-09-08 12:24||Michael Van Canneyt||Assigned To||=> Michael Van Canneyt|
|2019-09-08 12:24||Michael Van Canneyt||Status||new => resolved|
|2019-09-08 12:24||Michael Van Canneyt||Resolution||open => no change required|
|2019-09-08 12:24||Michael Van Canneyt||FPCTarget||=> -|
|2019-09-08 12:24||Michael Van Canneyt||Note Added: 0117988|