UTF, Oracle 10g table nvarchar2 column vs Delphi DBGrid
Posted: Thu 19 Oct 2006 11:27
Hello,
use Oracle 10g, Delphi 7 & ODAC 5.50.0.15
in Oracle NLS_NCHAR_CHARACTERSET = AL16UTF16
NLS_CHARACTERSET = WE8ISO8859P1
in Oracle table have column NCARHAR2(100)
under SQL Navigator can insert varios mixed data (cyrilic & latin etc like
ПРИВЕТ privet ПРИВЕТ) and all look fine, but in Delphi , standard DBGrid or TntDBGrid view it as ????
tested with Unicode = false or true, various CharSet , etc....
Where i can find ay demo for ODAC like some viewer for NVARCHAR2 columns or using UTF with ODAC
Hillar
use Oracle 10g, Delphi 7 & ODAC 5.50.0.15
in Oracle NLS_NCHAR_CHARACTERSET = AL16UTF16
NLS_CHARACTERSET = WE8ISO8859P1
in Oracle table have column NCARHAR2(100)
under SQL Navigator can insert varios mixed data (cyrilic & latin etc like
ПРИВЕТ privet ПРИВЕТ) and all look fine, but in Delphi , standard DBGrid or TntDBGrid view it as ????
tested with Unicode = false or true, various CharSet , etc....
Where i can find ay demo for ODAC like some viewer for NVARCHAR2 columns or using UTF with ODAC
Hillar