csm$errors [message #496607] |
Tue, 01 March 2011 05:29 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/136607.jpg) |
ramoradba
Messages: 2456 Registered: January 2009 Location: AndhraPradesh,Hyderabad,I...
|
Senior Member |
|
|
In what cases,Does csm$errors Has an error log of type 'DATA_LOSS'?(err#=2)
For Ex:
I have this type of error while changing character set.
For dictionary object Source$.source showing this error.
Does it mean its unable to convert it or any other info behind that.
What would be the remedy for this!
Sriram
|
|
|
|
|
|
|
|
|
Re: csm$errors [message #496641 is a reply to message #496640] |
Tue, 01 March 2011 11:51 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:And my question is why its failed any idea?
1/ Incorrect insertion of data.
2/ Some characters in WE8MSWIN1252 do not exist in WE8ISO8859P15
Regards
Michel
[Updated on: Tue, 01 March 2011 11:51] Report message to a moderator
|
|
|
Re: csm$errors [message #496643 is a reply to message #496641] |
Tue, 01 March 2011 12:12 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/136607.jpg) |
ramoradba
Messages: 2456 Registered: January 2009 Location: AndhraPradesh,Hyderabad,I...
|
Senior Member |
|
|
Quote:The same binary code point value can be used to represent different characters between the different character sets. Most European character sets share liberal use of the 8-bit range to encode native characters, so it is very possible for a cell to be reported as convertible but for the wrong reasons. When you set the FROMCHAR parameter, the assumption is that all character data is encoded in that character set, but the Database Character Set Scanner may not be able to accurately determine its validity.
For example, this can occur when the Database Character Set Scanner is used with the FROMCHAR parameter set to WE8MSWIN1252. This single-byte character set encodes a character in every available code point so that no matter what data is being scanned, the scanner always identifies a data cell as being available in the source character set.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14225/ch12scanner.htm#i1007101
I should read it and I will post the results here soon
Thank you
Sriram
|
|
|