Oracle 10g -> 11g Upgrade [message #671240] |
Sat, 18 August 2018 01:42 |
|
chris2018
Messages: 16 Registered: February 2017
|
Junior Member |
|
|
All,
there is a Oracle Express Edition (XE) 10g Release 2 (10.2.0.1) (Western European) version. It uses single-byte LATIN 1 charset WE8MSWIN1252. Is there any reason, one would chose this version over the universal one?
My actual questions:
- Is the unmanaged (?) Oracle .NET provider (Oracle.DataAccess.dll) considering the HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_XE\ODP.NET key, so that I can switch from WE8MSWIN1252 to UTF-8?
- Does the charset used internally by the ASP.NET 3.5 c# application matter? Where do I find it? Or is the ODP.NET provider guessing the input charset? Or is it always UTF-8?
- Is it possible to resize the columns from byte to char, expdmp the WE8MSWIN1252 database version 10 and import it to UTF-8 version 11?
Thank you in advance.
- Chris
[EDITED by LF: fixed formatting]
[Updated on: Tue, 21 August 2018 00:13] by Moderator Report message to a moderator
|
|
|