Zeoslib Portal

Hallo Michael, I decide that the TDS-Driver is the better decion for my purpose. The whole struggele with the converting of strings between ANSI-ASCII-UTF16-UTF8 is a holy crap. Nichts führ ungut! So is es. So I will stay at the TDS-Driver this made more sence, but i'll keep an eye of the oledb dirv...

sorry make a mistake ... forget the last post! :roll: The textfile has data with a fixed record length! when in load the file as myList.LoadFromFile('O:\TEST.DAT',TEncoding.ANSI); It looks ok, but the result of the utf8 converting is a shifting of data away from the orginal position. Without TEncodi...

so I make some tests.

Text File


...Var daten :

Results with : wideString, unicodeString ==> M?nchen
ansiString, RawByteString, String ==> M

Hello Michael, sorry for my late reply! Well i tested now the 1. Which column-type is used for the field? VARCHAR/NVARCHAR[?/MAX] ? with both fieldtypes the same result! 2. Do you use the new UTF8 feature of V2019? NO ---> because the production enviroment has various Verions of SQL-Server from 2012...

Hallo dear Zeosteam, well since years I use your DB-Tool and I must say it's the best on the (open-) marked. I try to move a way from the extern database-dirvers like freeTDS etc... and now I'm testing the OLDB connections. ======================================= ZeosVersion : 7.3.1-beta revision : ...

Hello @all Big tanks to all developers for this excellent database-tool! This is my problem: ----------------------------------------------------------------- ZEOS Version 7.1.3-stable on Lazarus #: 1.2.0 ( 32 Bit on 64 Bit Win 7 Prof) FPC-Version : 2.6.2 SVN-Revision : 44303 -----------------------...