Our application successfully communicates with various databases (MSSQL, Oracle, Firebird) via ADO, that's why I'm trying to use ADO to add the PostgreSQL option to our software. I use standard PostgreSQL ODBC provider. All was fine until I faced with the problem with the large TEXT fields. When I use Unicode version of the provider and try to get TEXT field AsString, the application is just crushed with EAccessViolation in method RemoveMediumFreeBlock(). ANSI version works, but it cuts the content of the field (I guess the characters besides default 8190 LongVarChar limit). Small TEXT fields are read OK. Could you suggest me what to do with this issue? Is there the better option to work with PostgreSQL via ADO in Delphi?
PostgreSQL + Delphi XE7 + ADO + ODBC
774 Views Asked by Alexander Popov At
0
There are 0 best solutions below
Related Questions in POSTGRESQL
- Why does adding a JOIN completely modify the query planner behaviour?
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- Aggregate and count in PostgreSQL
- Rails HABTM: Select everything a that a record 'has'
- Trigger using data from inserted row
- Select results where joined table contains records with an attribute, but without another
- DB candidate as CouchDB/Schema replacement
- How do I properly add data in SQLAlchemy?
- Postgres in Conda Environment (Ubuntu 14.04)
- How to customize the output of the Postgres Pseudo Encrypt function?
- Split a large query (2 days) into pieces to increase the speed in Postgres
- Why does pg_search prefix not work like I expect?
- extracting meta info from a table psql using information_schema
- How to query a table in the database and copy it's data into one one?
- Update a table using info from a second table and a condition from a third table in Postgresql
Related Questions in DELPHI
- How to not load all database records in my TListbox in Firemonkey Delphi XE8
- How to catch WM_DEVICECHANGE in a control other than TForm?
- show information with Rolling / moving messages delphi xe7
- What is the different between "Console target" and "GUI target" in DCC32 option?
- How to add new online ressources to RAD Studio help system
- C# and Delphi code have different behaviour when importing unmanaged dll
- Loop through records on a cxgrid and update a field/column
- Delphi 7 - Save to a Specific .INI Files Name
- TImagelist for large images
- how to modify a function so it returns an array of strings
- Checking for internet connection in runtime
- How can I make the main form align correctly after my control height is autosized and then I maximize the form?
- fetch data from web service to dataset in Delphi
- Load candlestick data from file
- Infinite loop in parsing a string using pointer math
Related Questions in ADO
- ASP Error 0223 - TypeLib Not Found, intermittent, resolved after IIS restart
- Accessing protected mysql names via ASP
- ADO Connection and Recordset = ""
- VBA - Using Typeof ... Is ADODB.Recordset Results in Compile Error
- Javascript ADO recordset open method not working. Parametrized queries
- Converting ADODB Loop into DAO
- ADO Close not releasing all memory - small leak
- "Identity cannot be determined for newly inserted rows" after ADO RecordSet AddNew and Update
- Classic ASP: Trouble processing SQL
- How to use a RecordSet.Find with TADOQuery?
- Creating a access db from a template
- ADODB CommandTimeout executing stored procedure in classic asp
- Delphi AdoConnection Reconnect
- Is there any direct API to find the matching items for the same index in a variant of the order var(a,b)?
- how to rewrite code from DAO to ADO?
Related Questions in TMEMO
- How to get values from a field and assign to a TStringList?
- TMemo max width
- How to get Scrollbar notifications from a TMemo control?
- Why CTRL+C is not working on TMemo component? (Vista + Delphi 7)
- Enable scroll bars in disabled TMemo control
- Delphi - How to add tabs in TMEMO?
- How to underline words after spell check using Delphi
- How to ask Delphi memo components (TMemo, TcxMemo) to recalculate line breaks? How to prevent the fixed wrapping of lines?
- Get the caret position (line and char) in an FMX TMemo
- Mouse Coordinates To Caret Position in Firemonkey TMemo Component
- How can I paste arbitrary data into a TMemo?
- Advanced TMemo functionality
- Memo and create file and folder?
- How do I find out the number of characters in a tmemo component?
- How to execute my custom action when right-clicking on a TMemo control?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?