Zeoslib Portal

Which means assign a TStringField with a UnicodeString Delphi cast the Strings down to AnsiStrings in the FieldBuffers and on reading vice versa. Curious? Yes it is. This is a right path, because table field is if fact AnsiString and the control use unicodestrings. So the conversion is right at thi...

My database is using ANSI encoding (WIN1250) My Delphi is unicode - XE. I have a code: Query.SQL.Text := 'SELECT Tekst FROM table'; with TStringField.Create(Query) do begin FieldName := 'Tekst'; Name := 'tableTekst'; Index := 0; DataSet := Query; end; Query.FieldDefs.Update; Query.Open; I get the ED...

Thanks.

I'll check how it works.

Postgresql allows to use character varying field type without field size limit, this allows storying a string with any length (max about 1GB chars). Create Table test ( testfield varchar ) Now I use a query: Select * from test In this case Zeos creates a string field for 'testfield' and limits its s...

Hi. I have an issue with 19.09.2012 SVN ZEOS testing branch. I'm using Delphi XE. How to reproduce: Start a new application Put ZConnection and two ZReadOnlyQuery on the form. Connect both queries to ZConnection Add whatever connection parameters to have a valid connect to any database. Add a button...

@tygrys This line: BinToHex(PAnsiChar(TempString), PAnsiChar(Result), Length(TempString)); I have found only in: zeoslib\trunk\src\dbc\ZDbcDbLibUtils.pas zeoslib\branches\testing\src\dbc\ZDbcDbLibUtils.pas zeoslib\tags\7.0.0-alpha\src\dbc\ZDbcDbLibUtils.pas However, in this thread we talking about ...

tygrys , Now you make me curious. I can't believe you are talking about \testing-egonhugeist. All your proposals are implemented. Just read the first post of this thread. I'm not sure about the MSSQL issue. But all other issues you report here are solved. Not on the trunk and not on testing but on ...

To clarify: Firebird 1.5 does not support UTF8 encoding at all. Postgresql (if not UTF8 codepage set in conection): See ZDbcPostgreSqlUtils line 230 and 263, 311, 724, 830. I think all {$IFDEF DELPHI12_UP} and then UTF8String(SQL) should be hunted in sources and used only if the connection encoding ...

Hi Egon There is a problem with ZEOS on firebird 1.5. There is no UTF8 encoding on connection, but strings are hardcoded to UTF8. Should be conditional. The problem still exists if codepage is not set to UTF8 on any other firebird version. See line 891 ZDbcInterbase6Utils.pas {$IFDEF DELPHI12_UP} Pl...

Hello tygrys ! And finally, when we start to work ? :D Contributing to Zeos code isn't that difficult nor is needed that you're the best developer in the world. You're probably a better developer than I am! If you aren't sure, start, propose, discuss, and someone will help you (us). That's the way ...

But nowadays in 7.0 the conversion is made {$IFDEF DELPHI12_UP}. And the encoding is forced to be UTF-8 As I said : I fully agree, but that's the way it has been developed by somebody who DID speand a lot of time to get things working, at leat under his development conditions. So, I'd like to talk ...

My idea about what *should* be done is - decide on an internal encoding to be used for sql strings and string data. Is this depending on the environment you're working in (windows/linux, locale, project setting, ...)? In that case the choice should be to use this encoding throughout the component a...

Hi Tygrys, I fully agree the encoding stuff looks clumsy. Main reason is : at some moment some very smart(?) people decided a string isn't a normal string anymore. What worked before just didn't anymore and we had to do a 'quick' conversion, while keeping old behaviour intact. But then, while testi...

Lucky you with 26 letters :-) I may understand how encodings and charsets work, but I have no knowledge on Zeos internals. So far, version 6.6 was ok for me with international character support. When I upgraded to XE I found problems with recompiling 6.6, so I installed 7.0. It compiles fine, but de...

On some database configuration 7.0 does not work well. ie. I have Firebird 1.5 database with win1250 encoding internaly. I'm also using polish windows (that means win1250 ansi internal) and I set connection properties to codepage=win1250. It works fine under delphi 2006, but under XE it destroys nat...