問題描述

我目前正在嘗試從我們限制從 Linux Web 服務(wù)器訪問的 SQL Server 數(shù)據(jù)庫(kù)視圖中提取一些數(shù)據(jù).

I'm currently trying to pull some data from a SQL Server database view that we have restricted access to from our Linux web server.

我們不需要編輯數(shù)據(jù)，只需將其顯示在網(wǎng)頁(yè)中即可.

We don't need to edit the data just display it in a webpage.

一切看起來都很好，直到我們嘗試輸出并且只獲取文本字段的前 255 個(gè)字符.

It all looks fine until we try to output and only get the first 255 characters of a text field.

有誰知道這是否是通過 PHP::PDO 使用 FreeTDS 的問題，或者它是否應(yīng)該可以正常工作?我見過其他人也有類似的問題，但似乎沒有多少答案.

Does anyone know if this is a problem with using FreeTDS through PHP::PDO or if it should work fine? I've seen other people out there having similar problems, but there don't seem to be many answers.

我將其用作 MS SQL 數(shù)據(jù)庫(kù)的連接字符串:

I'm using this as the connection string for the MS SQL db:

$dbConn = new PDO("odbc:Driver=FreeTDS;DSN=OURDSN;UID=WWWUser;PWD=ourpassword");

推薦答案

根據(jù) FreeTDS 用戶指南，問題似乎是 FreeTDS 在與 SQL Server 交談時(shí)只能處理 varchar 最多 255 個(gè)字符由于協(xié)議定義中固有的限制".任何比這更大的數(shù)據(jù)類型都需要text.

According to the FreeTDS User Guide, the issue seems to be that FreeTDS can only handle varchar up to 255 characters when talking to SQL Server "due to limitations inherent in the protocol definition". Anything bigger than that needs to be data type text.

您可以通過相應(yīng)地修改架構(gòu)或在查詢期間轉(zhuǎn)換數(shù)據(jù)類型來解決問題，如下所示:

You can resolve the issue either by modifying your schema accordingly, or converting the data type during your query, like this:

SELECT CAST(mycol as TEXT) FROM mytable

這篇關(guān)于MS SQL Server 上的 ODBC 查詢僅在 PHP PDO (FreeTDS) 中返回前 255 個(gè)字符的文章就介紹到這了，希望我們推薦的答案對(duì)大家有所幫助，也希望大家多多支持html5模板網(wǎng)！