1

Topic: Are lost characters

We have such basis
NLS_CHARACTERSET CL8ISO8859P5
NLS_NCHAR_CHARACTERSET AL16UTF16
In the register nls_lang RUSSIAN_CIS.CL8MSWIN1251
It was required  to write, it is impossible while even to deduce, somewhere
select to_nchar ('  '), '  ', to_nchar ('  '), dump (to_nchar ('  ')) from dual;
Deduces
??????? ?? ?? Typ=1 Len=4: 0,63,0,63
With RUSSIAN_CIS.AL32UTF8 too most.
All right to show on the screen that dump (to_nchar ('  ')) shows that there questions most of all guards.
What I do not so?

2

Re: Are lost characters

Cheese)));
How you N will thrust byte of the national coding in one byte of the one-byte coding?
Or change the basis coding (dbca + expdp/impdp), or store UTF in NCHAR fields

3

Re: Are lost characters

Vadim Lejnin wrote:

Cheese)));
How you N will thrust byte of the national coding in one byte of the one-byte coding?
Or change the basis coding (dbca + expdp/impdp), or store UTF in NCHAR fields

Sorry crookedly read a question smile

4

Re: Are lost characters

I also am going to store in nclob.
While to write down without? It is impossible as even to deduce to_nchar ('  ') I can not.

5

Re: Are lost characters

Cheese)));
'  ' is a constant in NLS_CHARACTERSET;
Therefore it is not necessary even to start to try to_nchar ('  ').
Begin with N '  ' is there will be a constant in NLS_NCHAR_CHARACTERSET

6

Re: Are lost characters

booby wrote:

'  ' is a constant in NLS_CHARACTERSET

Not a constant. A literal.
And about NLS_CHARACTERSET - is better to be specified, and that somehow spherically-vacuumly.

7

Re: Are lost characters

Cheese))) wrote:

While to write down without? It is impossible,

Or all the same to read. The characters lost at record are designated - and

8

Re: Are lost characters

Arsenyev wrote:

the characters Lost at record are designated - and

Sergey, is judgement that you are mistaken a little.

9

Re: Are lost characters

andrey_anonymous wrote:

it is passed...
Not a constant. A literal.
And about NLS_CHARACTERSET - is better to be specified, and that somehow spherically-vacuumly.

In! A literal.

10

Re: Are lost characters

andrey_anonymous wrote:

it is passed...
Not a constant. A literal.
And about NLS_CHARACTERSET - is better to be specified, and that somehow spherically-vacuumly.

It is a question of what to transform from something in somewhere it makes sense only in the event that "it" in that "from something" generally knows, distinct from a dial-up of substituting ' characters? '.
And when at '  ' there is no representation in NLS_CHARACTERSET that and in NLS_NCHAR_CHARACTERSET
To translate, except signs, a question there is nothing.

11

Re: Are lost characters

booby wrote:

it is passed...
It is a question of what to transform from something in somewhere it makes sense only in the event that "it" in that "from something" generally knows, distinct from a dial-up of substituting ' characters? '.

It is a question of that NLS_CHARACTERSET happens different.
The server.
Sessional (client).

12

Re: Are lost characters

andrey_anonymous;
Here excuse.
About that "NLS_CHARACTERSET happens different." I now do not know and before never knew.
About territory and language in session - about it heard, and about "different" NLS_CHARACTERSET - is not present.
So I can not claim for reduction a level  NLS_CHARACTERSET there, where it "different".
Excuse once again.

13

Re: Are lost characters

booby wrote:

about that "NLS_CHARACTERSET happens different." I now do not know and before never knew.

It is very sad.
But it is reparable.
If to esteem here
https://docs.oracle.com/database/121/NL … m#NLSPG189
And then  over a picture here
https://docs.oracle.com/database/121/NL … m#NLSPG185
That it is possible to realize that simple fact that transferred from the client the data can be presented in different codings.
And perception of these codings (in particular, whether reaches to to the server the text or a question sign) immediately depends on what coding was declared by the client at establishment of connection with the server.
It equally concerns and the texts of SQL queries sent from the client on the server.
For this reason the statement a little... .
Whether was available in view of database characterset or all the same client ?

14

Re: Are lost characters

andrey_anonymous;
That is told has been told precisely and literally.
It is more, not less.
In this connection sentences "" are not accepted.
There is a potentiality to say something informative in an assertive form - say.
Well and, by a sentence on a sentence,  on a subject to whom your semihints and allegories could be interesting.