Tema: Re: vel oracle ir charset
Autorius: Toxis
Data: 2011-07-11 21:25:23
chia win2008 R2 SP1 x64 servas, bet klientuose tas pats (tas pats ir 
2k3server)..
registre keichiau, nepadeda.. kas keischiausia, kad net neupdeitinus oraclo 
(shiuo atveju chia 11g) tik updeitinus softa (praleidus update scriptus) - 
nushoka charsetas. L2 supportas aishkina, kad chia oraklo esme ir reikia 
moket dba kad jis knistusi, bet kuj - kazhka jie pakeite softe, o ka - 
nerandu;)

"BrunoX"  wrote in message news:iverdo$dsg$1@trimpas.omnitel.net...

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
>