The ora-00997:illegal use of a long datatype error occurred while converting the long type to the CLOB type in Oracle 10.2.0.4.
Finally, use the To_lob () function to resolve:
INSERT into T_clob SELECT A, To_lob (B) from T_long;
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
Connecteatchd as Reporttest
Sql> CREATE TABLE T_long (A number, B LONG);
Table created
Sql> CREATE TABLE T_clob (A number, B CLOB);
Table created
Q: When drawing with CorelDRAW, the "Illegal operation of this program" appears, How to solve?
Why does it suddenly appear that "the program performs illegal operations and needs to be closed" when drawing in CorelDRAW? How to solve?
A: This is probably the most Coreldraw plotter headache, but Coreldraw12 later version of this situation is very rare, Coreldraw 9 and Coreldraw 10 This situation is most com
other hand, the readability of the code can be significantly reduced by thorough and meticulous error checking each time a method is invoked. Since programmers may still be using these languages to maintain their systems, they should have a deep understanding that if you control the error in this way, there will be no small hindrance in creating large, robust, maintainable programs.
①:C programmers look at the return value of printf ().
The solution is to exclude all contingency in error cont
database server has done so, a cold sweat ah!!! I said what else to do, he said also changed the configuration file, added an event, did not control it, simply did the following actions:MV My.cnf My.cnf.ori/etc/init.d/mysql startHaha, a long-lost start success hints came out finally. Then let him log in to look at the data right, look at the next no problem.Summarize:Finally through and his communication, the same environment, the same database version, the same configuration, only this one doe
MySQL replication case AReprint: http://www.vmcd.org/2013/09/mysql-replication-case-%E4%B8%80%E5%88%99/Posted by admin on September 10th, 2013Recently, a colleague has handled a MySQL replication error. Send for referenceMySQL synchronization error, the error message is as follows:?
last_errno:1267 last_error:error ' illegal mix of collations (utf8_ general_ci,coercible) and (latin1_swedish_ci,implicit) for operation ' Concat "on quer
Tags: nbsp ext value BSP Config quote success text systemSystem error When starting configuration file: Error parsing YAML config File:yaml-cpp:error at line 3, column 9:illegal map value First check that each parameter is properly configuredThe second step is to see if the file path is correct, when surrounded by double quotes in the path ("D:\MongoDB\data"), you should replace "\" in the path with "/" ("D:/mongodb/data")The third step is to see whe
Core ConceptsWAFWeb application Firewall (Web application Firewall), or WAF.Web attacksAttacks initiated against web apps, including but not limited to the following types of attacks: SQL injection, XSS cross-site, Webshell upload, Command injection, illegal HTTP protocol request, unauthorized file access, and more.waf--attacks against web apps, including but not limited to the following types of attacks: SQL injection, XSS cross-site, Webshell upload
The next log now has the title changed to "very simple code, but not ..."This blog address: http://www.cnblogs.com/herbertchina/p/4475092.htmlAfter many tests, the following hints are given:1. If you are 360 fast browser (360 browser not tested), please open it carefully: Load failure will cause crash, computer CPU will run crazy (CPU fan suddenly become faster), and finally cause the browser to crash2, if you are IE browser (beta version is IE11), can be unscrupulous3, if you are Google Chrome,
Today, when doing the project, there are two entities: style, brand relationship is many-to-many relationships, the realization of the function is: through the selection of styles, showing the style of all brands. The HQL statement is as follows:From Brand as b where b.styles.styleid=?This exception error occurred at runtime: Org.hibernate.QueryException:illegal attempt to dereference collection. through data found in the above hql statement, Brand's associated entity styles is a set set,
Disk self-healing features NTFS utilizes a "self-healing" system that automatically detects and fixes logical and physical errors on the hard disk. In the FAT16 and FAT32 times, we need to use the ScanDisk program to mark bad sectors on disk, but when errors are found, the data is often written in bad sectors, and the damage is done.
Computer illegal shutdown, accidental power outages and so on, the next time the boot or restart, Windows will perform
Analysis may be: Some of the ASP's reserved fields, the specific people can refer to this article: ASP common reserved word collation
Normally, the code is fine. The ID has a value but the library has been changed to SQL Server Library for a long time. So, what's the problem with this mistake?
Microsoft VBScript run-time error ' 800a01f5 '
Illegal assignment: ' Sqlstr '
/admin/list/savedate.asp, line 60
Error Line code sqlstr= "Delete d_31 where
looking for other posts.https://www.crifan.com/unicodeencodeerror_gbk_codec_can_not_encode_character_in_position_illegal_multibyte_sequence/4. Find another one,Http://www.jb51.net/article/64816.htmAs prompted, add encoding= ' Utf-8 ' When the file is opened, that is, With open ('e:\ Tomb Raider test22.txt'w', encoding=' Utf-8') as F:Problem solving.Reference"Summary" errors in the coding and decoding of common characters in Python 2.x and their solutionsUnicodeencodeerror: ' GBK ' codec can
Using Iconv () to convert a character that is not supported by an output character encoding, such as Iconv (' UTF-8 ', ' GB2312 ', ' embarrassing '), you may encounter such error prompts:
Notice:iconv () [Function.iconv]: detected a illegal character in input string ...
Because GB2312 is simplified Chinese and does not support more complex Chinese characters such as "embarrassing" and some special characters, this will certainly be an error, and the
VC6.0 Engineering at compile time because of the setup problem sometimes does not generate release version, only the debug version.
The settlement offender is illegal as follows:
Engineering-Settings, change the setting for later option to Win32 release. and recompile.
If you still do not generate release with this method, and you are still Win32 Debug when you turn on the settings, right-click on the VC6.0 toolbar, select Build, and remove build m
[SQL]View plain Copy Select A.equ_no, b.fullcode from Equipment A, (select t.*, Getequtypefullcode (t.equtype_id) as Fullcode from Equ_type t) b WHERE Substri Ng (A.equ_no, 1, 5) = B.fullcode error is as follows:
[plain] view plain copy [ERR] 1267-illegal mix of collations (utf8_unicode_ci,implicit) and (Utf8_general_ci, implicit) for operation ' = 'WORKAROUND: Convert the comparison equation side to string, such as "Convert (B.fullcode USING UTF8) C
Can't input! @#¥%......* The regular expression of this type of character:/[@#\$%\^\*]+/g This is to contain any one of these special characters. Take! CanAlert (!/[@#\$%\^\*]+/g.test ("test")) returns false to mean that it does not contain illegal characters.
PS: About regular expressions, here again provides 2 of the online Regular expression tool for everyone to reference use (including common regular generation, matching, testing, etc.):
JavaScr
In the process of inserting Chinese into MySQL, the system complains:
Illegal mix of collations (latin1_swedish_ci,implicit) and (Utf8_general_ci,coer)
This is because the MySQL default encoding format is not the same as the data stored in the format, the solution:
Open MySQL installation directory, which has a My.ini file, open this file, there are two sets of character sets, the default is Latin (latin1), suggest you want to change, such as: UTF8 or
Today, listen to a friend said that they have a colleague with MDaemon Worldclient log in to the mail server, after entering the username and password, pop-up a prompt box, prompt: The IP address of the request session is illegal.
Rationale: MDaemon has an additional security measure that, at the beginning of the session, the default worldclient will monitor the IP address specified by the default domain and the additional domain, limiting the IP add
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.