Data storage and reading problems

[mmcgzs]

I use varchar (max) to save a text (UTF-8), the length is 14,000 bytes or so, when read with tiny_tds only read 4096 bytes.
Try to use text or nvarchar (max) or ntext these types, can not read the full content.
Want to know what the problem is caused, how to solve?

Here is test code:
client = TinyTds:: Client.new (: username => 'gim',: password => '123qwe !@#',: host => '192 .168.2.74 ',: database =>' bbs')
r = client.execute ("select * from replies where id = 1078")
r.first ["content"]. size

[metaskills]

Remember, there is a TEXTSIZE setting in SQL Server that limits for memory performance. You should check it out. A default is assigned to all client connections. Flavor to your needs.

http://msdn.microsoft.com/en-us/library/aa259190(v=sql.80).aspx