No question at this time
DBA Top 10
1 B. Vroman 15700
2 M. Cadot 10200
3 T. Boles 8350
4 J. Schnackenberg 8300
5 A. Kavsek 7800
6 M. Hidayathullah ... 2500
7 P. Wisse 1200
8 G. Lambregts 1100
9 T. P 1000
10 B. Derous 500
10 R. Pattyn 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48277
Total active users1612
Act. users last 24h4
Act. users last hour0
Registered user hits last week185
Registered user hits last month836
Go up

Special Charecters
Next thread: Trying to create a procedure to load partition data form one database to another using db links
Prev thread: Does truncate/delete requires table reorgnization or not ?

Message Score Author Date
Hello All I need to store special char in oracle ...... Touseef safdar Mar 29, 2018, 14:36
Dear, for character related, i would suggest yo...... Mirza Hidayathullah Baig Mar 29, 2018, 16:21
Hello Touseef, two important things to understa...... Score: 500 PtsScore: 500 PtsScore: 500 PtsScore: 500 PtsScore: 500 Pts Bruno Vroman Mar 29, 2018, 17:09
ou have to ensure that all character sets you se...... Michel Cadot Mar 29, 2018, 17:11

Follow up by mail Click here


Subject: Special Charecters
Author: Touseef safdar, Pakistan
Date: Mar 29, 2018, 14:36, 206 days ago
Os info: Linux
Oracle info: 6.8
Message: Hello All
I need to store special char in oracle database 12c like 'ł, ć, ó' but i cant store i returs the result ????? so please suggest what should i do to store that type of char
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Special Charecters
Author: Mirza Hidayathullah Baig, United Kingdom
Date: Mar 29, 2018, 16:21, 206 days ago
Message: Dear,

for character related, i would suggest you to go through following mos note

The National Character Set ( NLS_NCHAR_CHARACTERSET ) in Oracle 9i, 10g , 11g and 12c (Doc ID 276914.1)

Regards
Mirza
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Special Charecters
Author: Bruno Vroman, Belgium
Date: Mar 29, 2018, 17:09, 206 days ago
Score:   Score: 500 PtsScore: 500 PtsScore: 500 PtsScore: 500 PtsScore: 500 Pts
Message: Hello Touseef,

two important things to understand:
a) the database has a character set that "defines" what can be stored in the database or not.
b) the client session has its own character set, that can be different of the server character set (this is common).

Note that a common mistake is to think that the client must use the same charset as the server.

If server and client don't use the same charset, there is an automatic "translation" done when data is exchanged (in the two directions). For example if the server is using AL32UTF8 and client is using WE8MSWIN1252, an "é" sent by the client is using a single byte, and this is translated to the multibyte "é" in the server; the same applies in the other direction: if the client selects an AL32UTF8 "ç" stored in the server, it will receive a WE8MSWIN1252 "ç".

It is very important to define correctly the charset used by the client session otherwise the "translation" might give wrong results (or it might be "skipped").
This is done by providing the correct value to NLS_LANG

Remark: if the client doesn't have a character stored in database, the server will try to give the best translation; example; if a WE8ISO8859P15 server has to send an "é" to an US7ASCII client, it will rather send "e". If there is no replacement character, the client will see something like "¿" or a "small square" or "?"...

You might have a look at the following note:
  158577.1 NLS_LANG Explained (How does Client-Server Character Conversion Work?)

Best regards,

Bruno Vroman.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Special Charecters
Author: Michel Cadot, France
Date: Mar 29, 2018, 17:11, 206 days ago
Message:
ou have to ensure that all character sets you set between the client/server/database support the characters you want.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here