sqlserver2000 convert(text,content) 数据少取了解决方案
sqlserver2000 convert(text,content) 数据少取了
select convert(text,content) as content from..
使用php，用这种方法只能取2K数据，多了就自动截取了,不使用convert就出错了。 怎么解决？
------解决方案--------------------
为什么要用 convert ？
不使用convert就出错了 出什么错 ？
你的 convert 是什么类型的？ 保存了什么内容？
2K 好像是 sqlserver2000 char或varchar类型的上限吧？你先核实一下
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
What software is convert?
Dec 09, 2020 am 09:33 AM
convert is not a software, but a file system modification command in Windows. Convert converts the file allocation table FAT and FAT32 volumes to the NTFS file system while leaving the existing files and folders intact. Its syntax is "convert [Volume] /fs:ntfs [/v] [/cvtarea:FileName] [/nosecurity] [/x]".
How to use convert command
Oct 25, 2023 pm 02:55 PM
The convert command is a command line tool in the ImageMagick image processing software package, used for image format conversion, image processing, and image synthesis. Common usage: 1. Simple image format conversion: convert input.jpg output.png; 2. Adjust image size: convert input.jpg -resize 800x600 output.jpg; 3. Image cropping, etc.
How to use the convert conversion function
Nov 16, 2023 pm 01:09 PM
The usage is to understand the data type and target data type to be converted, and call the corresponding conversion function to achieve the conversion.
How to implement date comparison, sorting and other operations with the varchar type in mysql
May 31, 2023 pm 01:49 PM
During the use of MySQL, dates are generally stored in datetime, timestamp and other formats. However, sometimes due to special needs or historical reasons, the date is stored in varchar format. So how should we process the date data in varchar format? ? Use function: STR_TO_DATE(str,format) The STR_TO_DATE(str,format) function is the inverse function of the DATE_FORMAT() function. It takes a string str and a format string format. STR_TO_DATE() returns a DATETIME value if the format string contains date and time components, or if the word
What is the difference between char and varchar in mysql
Sep 04, 2023 pm 02:16 PM
The differences between char and varchar in mysql are: 1. CHAR is fixed length, while VARCHAR is variable length; 2. CHAR storage and retrieval efficiency is high, while VARCHAR storage and retrieval efficiency is not high; 3. CHAR takes up storage space, VARCHAR can save storage space.
Detailed tutorial on Apache optimization and hotlink prevention in Linux system
Feb 20, 2024 am 09:00 AM
The following is a detailed tutorial on Apache optimization and anti-hotlinking under Linux systems: Apache performance optimization: Enable compression: Enable Gzip compression in the Apache configuration file to reduce the size of transmitted data. LoadModuledeflate_modulemodules/mod_deflate.soAddOutputFilterByTypeDEFLATEtext/htmltext/plaintext/xmltext/cssapplication/javascript
CSS content properties explained: content, counter, and quotes
Oct 21, 2023 am 10:16 AM
Detailed explanation of CSS content attributes: content, counter and quotesCSS (cascading style sheets) is an integral part of front-end development. It can help us beautify web pages and enhance user experience. In CSS, there are some special properties that can be used to control the display of text content, including content, counter, and quotes. This article explains these properties in detail and provides specific code examples. 1. content attribute content attribute
How does MySQL determine the size of VARCHAR
May 27, 2023 pm 09:20 PM
First of all, it is not recommended to use the TEXT type, because using TEXT will seriously affect efficiency. The best way is to use VARCHAR and determine the maximum length of the field. We can first define a field rule_value in the table and set the length to 255, then enter the smallest json string: use MySQL's CHAR_LENGTH function to calculate the size of rule_value: SELECTid, rule_type, rule_value, CHAR_LENGTH(rule_value) as rule_value_length, rule_markFROMtest_tableWHEREr
