Loading of foreign text [message #454527] |
Thu, 06 May 2010 04:00 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Ravin_C
Messages: 38 Registered: February 2008 Location: United Kingdom
|
Member |
|
|
Hi guys,
When i load a name such as 'DÂ'Costa' using sql loader, after loading in Oracle it becomes 'D¿Costa'.
Any ideas guys?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: Loading of foreign text [message #454788 is a reply to message #454777] |
Fri, 07 May 2010 07:41 ![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: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
And even then, the ASCII code could be correct for a character set and not for the other, the character should been converted and then is a valid one but not correct one for the data, and so on.
For instance, if I import "é" in a US7ASCII database it is converted to "e" but not all "e" comes from an "é".
Regards
Michel
[Updated on: Fri, 07 May 2010 08:06] Report message to a moderator
|
|
|
|
|
|