I haven't updated my blog for a long time. I encountered this problem when I was writing my website on ASP.net. The error message "truncates string or binary data. The statement has been terminated ."After debugging, it is found that during data
Function length (S: String {string; or an array}): integer;
Example:
// String (same as ansistring in Delphi 2007) var S: string; I: integer; begin S: = 'delphi '; I: = length (s ); showmessage (inttostr (I); {6} end;
//
The space function bitsCN.com in a string or field is deleted in mysql.
Ltrim functions
The code is as follows:Mysql> select concat ('.', ltrim ('http://www.hzhuti.com/nokia/n76 '),'.');
Rtrim functions
Mysql> select concat ('.', rtrim ('ddd '),
The following error occurs during debugging of SQL database addition:
Error! [8152] system. Data. sqlclient. sqlexception: truncates string or binary data. The statement has been terminated. At system. Data. sqlclient. sqlcommand. executenonquery ()
In java, XStream is used to convert an object to an xml string or convert an xml string to an object =
We often have requirements, such as calling others' interfaces, and others will return data in json or xml format to you. Then we need to convert
Convert into secondsThe date class has a gettime () that can swap back the number of seconds, for example: Public class datetosecond{publicstaticvoidnew Date ( System.currenttimemillis ()); System.out.println (Date.gettime ());}}Convert to string
How to get the JSON format string or object returned by Baidu coordinates API?
JSON is not very familiar, such as calling this interface http://api.map.baidu.com/ag/coord/convert?from=2&to=4&x=116.40624058825688&y=
JS and a hrefNotice the semicolon ending in the href, closing the quotation marks.href= "javascript:;" > Empty link a>href= "javascript: Alert (' a '); > popup a>Generally, it may be the code, generally let it empty. Empty can also use the pound
When submitting with Ajax, the JSON should be in the form of a string;The content of the response, depending on the settings, may be in the form of an object, or it may be in the form of a string.If it is a string, it can be converted into an object
Writing a shell script inevitably encounters the steps that require interactive input instructions:Method One:# Cat Action.sh#!/bin/shRead-p "Enter Number:" No;Read-p "Enter Number:" Name;echo you have entered $no, $name;# sh action.shEnter
Pick Grass from W3The slice () method returns the selected element from an existing array.GrammarArrayobject.slice (Start,end)
Parameters
Description
Start
Necessary. Specify where to start the selection .
Deletion of the space function in a string or field in mysql ltrim function mysql> select concat ('. ', ltrim ('ddd '),'. '); rtrim function www.2cto.com mysql> select concat ('. ', rtrim ('ddd '),'. '); trim string function, which is really
Jstl the value in the map, generally need to be compared to whether it is a key, only take out the value of the map, if the front splicing key is a string or shape, the direct fetch is not out, need to convert, the conversion is very simple, key+0
JS and a href className JS compile the sequence and run the sequence string or variable embedded in brackets instead of the point number represents the attribute, hrefclassnameJS and a href
Note The End Of The semicolon in href and close the
Organize several common GUIDs into 16-bit strings or 19-bit unique string methods: // /// 16-bit unique string based on GUID ///Author: Hui Yifang // /// /// Public Static string
How to flip a string or list in Python, and how to flip a string in python
1. reversed
class reversed(object) | reversed(sequence) -> reverse iterator over values of the sequence | | Return a reverse iterator | | Methods defined here: | | _
Browser compatibility problems in IE compatibility mode SCRIPT1028: The identifier, string, or number is missing, and the script1028 identifier
Directly run the Code:
No previous Code modified
Var ajaxPost = function (url, data, callback ){$. Ajax ({
System. Data. sqlclient. sqlexceptionThe string or binary data is truncated.The statement has been terminated.
This problem occurs because the field size of the temporary table that will be truncated during table creation. Then, when the row is
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.