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