Tema: Re: vel oracle ir charset
Autorius: BrunoX
Data: 2011-07-11 15:47:52
Su kuo dirbama? Oraclo klientas ar serveris, versija?
Gal padetu registre sukurimas\modifikavimas NLS_LANG su reiksme 
LITHUANIAN_LITHUANIA.BLT8MSWIN1257

"Toxis@ze_yval_place" <tox@work.ble> parašė naujienų 
news:ivenql$80m$1@trimpas.omnitel.net...
> 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
>