Tema: vel oracle ir charset
Autorius: Toxis@ze_yval_place
Data: 2011-07-11 14:46:29
Gal kas susidures, turejot panasiu problemu..
targetine mashina yra:
QL> SELECT *
  2  FROM nls_database_parameters
  3  ;

PARAMETER                      VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE                   AMERICAN
NLS_TERRITORY                  AMERICA
NLS_CURRENCY                   $
NLS_ISO_CURRENCY               AMERICA
NLS_NUMERIC_CHARACTERS         .,
NLS_CHARACTERSET               WE8MSWIN1252
NLS_CALENDAR                   GREGORIAN
NLS_DATE_FORMAT                DD-MON-RR
NLS_DATE_LANGUAGE              AMERICAN
NLS_SORT                       BINARY
NLS_TIME_FORMAT                HH.MI.SSXFF AM

PARAMETER                      VALUE
------------------------------ ----------------------------------------
NLS_TIMESTAMP_FORMAT           DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY              $
NLS_COMP                       BINARY
NLS_LENGTH_SEMANTICS           BYTE
NLS_NCHAR_CONV_EXCP            FALSE
NLS_NCHAR_CHARACTERSET         AL16UTF16
NLS_RDBMS_VERSION              10.2.0.4.0


Mashina i kuria keliu gali but absoliuchiai bet kokia, bet jei naujasne 
softo versija - visos lietuvishkos raides pavirsta "?". Bandzhiau keist 
vidini charseta i lietuvishka ( ALTER DATABASE CHARACTER SET INTERNAL_USE 
BLT8MSWIN1257; )  - tokiu atveju, visi nauji irasai - pasaka, lietuvishki, 
valio, visi seni irashai su ?tukais vietoj lietuvishku raidzhiu. Atsidarus 
sena irasha pakeitus ? i ęąčėčęį - viskas gerai, bet pereidinet ir redaguot 
kiekviena irasha - out of question, ju tiesiog fizishkai per daug...
Bandzhiau visa duombaze keist I lietuvishka (ne tik charseta) - nepadeda, 
bandzhiau keist i al32utf8 (berods) visos lietuvishkos raides tampa 
"ĄČĘĖĖŠĮŲŽ"...
target duombaze yra Export done in WE8MSWIN1252 character set and AL16UTF16 
NCHAR character set...
Musu softo mothershipas (L2) sako, fyg, chia oracle issue - eik mushk 
oraklistus, nors ash galiu net nekeist oraklo versijos, tiesiog upgreidint 
softa per viena laipta ir viskas nushoka... gal kas turejot patirties?
buchiau dekingas uzh bet koki tipsa, nes krushuosi jau antra savaite.. 
baigesi mintys:)
-- 
______
©Toxis