Timeline for Return text from PostgreSQL (9.6) to SQL Server from linked server query
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 22, 2017 at 11:51 | comment | added | simpleuser008 | i have to test it when i have more time, splitting output to 4000 chars in postgresql and parsing it together in sql server is good enough solution for now. | |
| Feb 21, 2017 at 14:55 | comment | added | Evan Carroll | @simplexio Set it back to -4 and disable prefetch if possible: connect.microsoft.com/SQLServer/feedback/details/615000/… if that doesn't work. Try casting geos::varchar(8000) or whatever. | |
| Feb 21, 2017 at 13:14 | comment | added | simpleuser008 | There is no value for MaxlongVarcharSize which works. i tried 4k/8k/16k/32k (varchar(max) value is always corrupted after 4000 chars) , -4 gave me error and did not work at all. so , at the end i went around the problem. | |
| Feb 16, 2017 at 6:09 | history | edited | Paul White♦ | CC BY-SA 3.0 |
Formatting; spelling; toned down slightly
|
| Feb 15, 2017 at 7:24 | comment | added | simpleuser008 | Well, reason why i use wkt is that i did not get varbinary(max) <-> bytea to work, but i have to see it again. Using SQL server is GIS sub-optimal but you cannot always select your stack. | |
| Feb 14, 2017 at 20:56 | history | answered | Evan Carroll | CC BY-SA 3.0 |