Additional
dbCAP
AnyDAC
ThinDAC
NCOCI8
Topic: Cannot show cyrillic
Cannot show cyrillic
Posted: 2007/10/02 17:28
 
Hi,

I have problem with visualizing of cyrillic letters. Database is Oracle 9.2. As you can see on attached file on other component fields are shown correctly but neither NCOCI8 nor AnyDAC letters are correct shown. Have you idea why?

Best regards,
Dobri

Post edited by: dobri, at: 2007/10/02 17:32

Post edited by: dobri, at: 2007/10/02 17:35
Re:Cannot show cyrillic
Posted: 2007/10/02 22:37
 
Hello

I need more info:
1) What is your CREATE TABLE ?
2) Execute query:

 SELECT FROM v$nls_parameters WHERE parameter LIKE '%CHARACTERSET%'


and post result here.
3) What do you mean "letters are not correct shown" ? All characters are replaced by question marks or how else ?
4) What is your client NLS_LANG ?
5) The same data is returned correctly by other tools, like a SQL*Plus ?

Regards,
Dmitry
Re:Cannot show cyrillic
Posted: 2007/10/03 01:24
 
Hi Dmitry.

1) I have no idea, because database is not mine.

2)
NLS_CHARACTERSET WE8ISO8859P1
NLS_NCHAR_CHARACTERSET AL16UTF16

3)For example: TADQuery return me recordset like this:

NOII-50o30-1.4-NA |  | - | BG |dat | 7898532 |1

Original is:
ÑÒÊÐ-50õ30-1.4-ÑÂ |  | - | BG |dat | 7898532 |1

4) What do you mean? I write now on Delphi application which have to read data from Oracle.
5) The same data is returned from other Delphi component from ODAC package.



Regards,
Dobri
Re:Cannot show cyrillic
Posted: 2007/10/03 01:33
 
Could you post here your demo project with NCOCI8 and ODAC ?