| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle does not (always) understand French - was RE: Use of the q uote / apostrophe in text fields
"best" is such a relative term (as in: "it depends") that it spells
"jobsecurity" for any consulancy-speaker at many Oracle-meets. :-)
Anyhow, either you *can* represent your desired character in the client AND the database set or you *can not*. Whether the character is essential for your language is your choice. Depending on whether the desired character is missing in the client set or the database set and your storing or retrieveing you get the various combinations of substitue characters (the accentless E) or the "?"-character. And if you lie (as in define the wrong characterset to the one you are using) you get "corrupted" characters. (I wont bore you with al the combinations just now). Som charactersets in Oracle have a defined Substition Table where it is specified what character to use in the defined set to store a character not in the defined set (thats what happened with the appstrophed-E). The default is to substitute the "?" (or inverted "?", depends on the set).
To see what characters you DO have in your client and database set use the Locale Builder (lbuilder - names varies slightly with platform), if your Java/GUI can cope with it you can see the characters. us ethe Open File By Object and select the characterset to exmaine, then go to the CharacterMapping tab.
M-square
Nuno Souto wrote:
> This is actually an interesting problem. Coming from a background
> of "`,',and ç" stuff myself, these things are somewhat relevant.
> Does anyone know of a reference on which characters and native
> languages are best supported by each of the WE8* and US7* settings
> and their relationships to the client?
>
> Cheers
> Nuno Souto
> in sunny Sydney, Australia
> dbvision_at_optusnet.com.au
> ----- Original Message -----
> From: "Robson, Peter" <pgro_at_bgs.ac.uk>
>
> Actually, this conundrum is all down to different character sets (
> WE8ISO8859P1, and US7ASCII ) being established on different instances. Oh
> Really... Just something to watch out for.
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue Mar 16 2004 - 09:55:21 CST
 |
 |