Zeoslib Portal

I also have problems but with nvarchar fields ... an error about utf standard. Converting nvarchar to varchar column lose the error but i have to investigate/replicate the error. Hope to give you an example about this issue also. Activating debug on freetds may help also with your issue. (TDSDUMP or...

Hi!
Acording to this http://technet.microsoft.com/en-us/libr ... l.80).aspx it's also suported since sql2000.

I'll try it tomorow on an instance but i'm sure of it because i made this modification some time ago and we have clients on sql2000 (hoping to upgrade soon).

On MSSQL we can use 3 ways of getting last inserted identity in a table 1.@@IDENTITY which gets last inserted identity 2. SCOPE_IDENTITY() which gets last inserted identity in current scope 3. IDENT_CURRENT( 'table_name' ) which gets the last identity value generated for a specified table or view. I...

The issue is happening also when using varchar columns or varbinary columns and using db editors for rtf ( Rich text format).

In unit ZDbcDbLibUtils.pas is used to replace #0 in string format for "stAsciiStream, stUnicodeStream, stBinaryStream:" with ''. The Delphi StringReplace function (at least Delphi 7 or Delphi XE2 one) uses AnsiPos and later StrPosLen witch ignores the #0 character so the replacement does n...

Small fix for setting the version after login on MSSQL using FreeTDS. if not Assigned(Result) then must be if Assigned(Result).

patch in atachment

Please see this..

http://zeos.firmos.at/viewtopic.php?t=3105

It should resolve your problem.

i have a unit composed from tZConnection connected to mssql using ntwdblib tZQuery using tZConnection with following sql SELECT top 1 name, convert(varchar(100), '') as name1, name as name2 from sysobjects when open query return for name1 column the value of name column i traced the problem into ZDb...