oracle - NLS_NCHAR_CHARACTERSET explanation -


Should I start I Oracle user'm not an expert so I Basics undestanding some problems: D. Our application is an MVC one with Nhibernate DB connection. When we try to save characters such as 'Ѽó' in the NRHARAR area, then give them a question mark '?' As is saved. To correct this we changed the database to a different charset.

Our Anels_detabes_prametrs to establish here:

  Anels_elaanajian American Anelsdayreria USA Anelskyuararansi $ Anels_aisaisiuaruaransi USA Anels_anaaraanaiaaraaraactors., Anels_caraketrsiti EE 8 ISO 885 9 P 2 Anelskalender Gregorian NLS_DATE_FORMAT DD- Mon. -arar NLS_DATE_LANGUAGE American NLS_SORT binary NLS_TIME_FORMAT HH.MI.SSXFF AM 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 Wrong NLS_NCHAR_CHARACTERSET AL16UTF16 NLS_RDBMS_VERSION 10.2.0.4.0  

Originally NLS_CHARSET EE8ISO8859P2 and we changed it to: AL32UTF8 (Does a thorough job). The question is, is the NLSNNCRRRARATERES not ready to handle those special characters for areas like ENVIRONMENT 2? If not, can someone please explain to me your purspose are

Edit: set NLS_LANG: POLISH_POLAND.AL32UTF8

National chaaterates were used in earlier times, i.e. before unicode becomes available. The main idea where language independent item shop to VARCHAR2 / CHAR (any source, including code, etc.) is common Charaterset and a customer-specific, ie language charatersset to specific national NVARCHAR2 / CHAR .

In my opinion, there is no reason to use it nowadays, since AL32UTF8 (or any other Unicode coding) is able to store any character anyway. Is

Maybe you non AL16UTF16 or a national charaterset work in Western languages ​​ AL32UTF32 slightly beneficial in terms of storage and efficiency Are there. About

If you query: National Charters AL16UTF16 is able to store any Unicode fodder, so you polish characters should not be a problem. However, your client applications (or selected fonts) may not be able to display such characters


Comments

Popular posts from this blog

winforms - C# Form - Property Change -

javascript - amcharts makechart not working -

java - Algorithm negotiation fail SSH in Jenkins -