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
> 
3Dastronomyagricultureaudioautosautos.audiautos.audioautos.binariesautos.bmwautos.clubautos.fordautos.hondacrxautos.japanautos.mercedesautos.opelautos.sportautos.volvoautos.vwaviaavia.binariesbankcardsbinariesbooksbuildingcinemacommercecomp.hardwarecomp.softwarecomp.lietuvinimascomp.networksculturedarbas.ieskaudarbas.siulaudesigneconomicselectronicsfaunafauna.aquafauna.binariesfishingflorafotofoto.binariesgamesgames.csgames.onlinegsmgurmanaihumourhumour.binariesinternetlawmicrosoftmotomusicmusic.binariesmusic.instrumentsmusic.LT.binariesnavigacijaphppoliticsprogrammingrpgsportstudyingsveikatatalktesttranslationtransportationtraveltravel.binariestvunixvideovideo.binarieswatersportswwwwww.flashpdaautos.supermama.ltmobiledarbasretro.3Dretro.agricultureretro.astronomyretro.audioretro.autosretro.autos.audiretro.autos.audioretro.autos.binariesretro.autos.bmwretro.autos.clubretro.autos.fordretro.autos.hondacrxretro.autos.japanretro.autos.mercedesretro.autos.opelretro.autos.sportretro.autos.supermamaretro.autos.supermama.ltretro.autos.volvoretro.autos.vwretro.aviaretro.avia.binariesretro.bankcardsretro.beosretro.binariesretro.booksretro.buildingretro.cinemaretro.commerceretro.compretro.comp.hardwareretro.comp.lietuvinimasretro.comp.networksretro.comp.softwareretro.cultureretro.darbasretro.darbas.ieskauretro.darbas.siulauretro.designretro.economicsretro.electronicsretro.e-vejasretro.faunaretro.fauna.aquaretro.fauna.binariesretro.fishingretro.floraretro.fotoretro.foto.binariesretro.gamesretro.games.csretro.games.onlineretro.games.rpgretro.genealogijaretro.gsmretro.gurmanairetro.humourretro.humour.binariesretro.internetretro.YZFretro.YZF.nebukretro.YZF.nebuk.netikintisretro.YZF.nebuk.netikintis.bukretro.YZF.nebuk.netikintis.buk.tikintisretro.lawretro.microsoftretro.mobileretro.motoretro.musicretro.music.binariesretro.music.instrumentsretro.music.LTretro.music.LT.binariesretro.navigacijaretro.newsretro.news.taisyklesretro.newuserretro.pdaretro.phpretro.politicsretro.programmingretro.rpgretro.sportretro.studyingretro.sveikataretro.talkretro.translationretro.transportationretro.travelretro.travel.binariesretro.tvretro.unixretro.videoretro.video.binariesretro.watersportsretro.wwwretro.www.flashdiylt.rkm.news.announcelt.rkm.news.newuser