Character Set

[DbaRrez]

Hi,

I have win 2003 server, with regional setting default english(USA). Ia have installed oracle 10g database, with character set al32utf8. I thought that this character set will support latin serbian characters??, but it not.

Do you have any idea how to not see ?? when I write latin serbian character.

Thnx
DBA_DBA

 

[SantaMufasa]

DBARrez,

Welcome to Tek-Tips!

Could you please copy and paste here to this thread a sample string of the "Latin Serbian" characters you wish to store in your database?

Thanks,

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”

 

[DbaRrez]

Hi,


Characters are:
?, ?, ?, Ž, Š.

Thnx,

 

[SantaMufasa]

DBARrez,

The database character set is only part of the "character-set equation". Another part is the client-machine character set.

To determine where your challenges lie, I suggest the following steps:[ul][li]Identify the ASCII code for each of the characters you wish to check (e.g., "A" = 67, "a" = 97, "B" = 68, et cetera). [I don't know what the proper ASCII values are for your character sub-set, "?, ?, ?, Ž, Š."][/li][li]From a SQL prompt, determine the results of these queries:

select ascii('?') from dual;
select ascii('?') from dual;
select ascii('?') from dual;
select ascii('Ž') from dual;
select ascii('Š') from dual;

Also,

select chr(<ASCII value for '?'>) from dual;
select chr(<ASCII value for '?'>) from dual;
select chr(<ASCII value for '?'>) from dual;
select chr(<ASCII value for 'Ž'>) from dual;
select chr(<ASCII value for 'Š'>) from dual;

[/li][li]Determine if the results of the above queries match your expectations.[/li][li]Determine the database storage behavior: INSERT (into a test table) the ASCII values for the sample characters:

INSERT into test_table values (chr(<ASCII value for '?'>));
INSERT into test_table values (chr(<ASCII value for '?'>));
INSERT into test_table values (chr(<ASCII value for '?'>));
INSERT into test_table values (chr(<ASCII value for 'Ž'>));
INSERT into test_table values (chr(<ASCII value for 'Š'>));

[/li][li]Query to see if the database has altered those values using this query:

select <column_name>, chr(<column_name>) ASCII_Val from <table_name>;

[/li][li]If the display of the ASCII_VAL column contents differs from the ASCII numeric values that you INSERTED, then, yes, the database character set is causing problems. If the ASCII numeric values are correct, but the display of the character translation is incorrect, then your client-machine character set has problems.[/li][/ul]

Let us know your findings.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”

 

[DbaRrez]

Dear Mufasa,

Even in selection:

select ascii('?') from dual;

I cant write proper character. It changes to C ??
select ascii('C') from dual;

And then yes it writes value C, which is not proper...

can it be that toad does limits???

DBARR

 

[sem]

It may depend on NLS_LANG value and OS locale. If you may type that characters in editor then most probably the last is OK. Otherwise change your regional settings.

Regards, Dima

http://seminihin.narod.ru

 

[DbaRrez]

Hi,

Even with Unicode database character set AL32UTF8 I can't insert latin serbian characters such as "?, ?, ?, Ž, Š" with toad, but connecting with ODP.net I can see proper characters.

With toad I just can see these characters while writing but in a moment that I press enter these two characters ?, ? are replaced with ansi C.

I wanted to know if there is a toad that converts these charatcers to ansi or oracle??, and is there any solutions to this??

thnx
DBA