August 30, 2008 12:12am pdt

1. sdstuber 76,560
2. schwertner 46,010
3. angelIII 25,957
4. aiklamha 24,600
5. johnsone 18,656
6. MikeOM_... 13,300
7. jinesh_ka... 12,950
8. dbmullen 12,900
9. dvz 11,789
10. Akenathon 9,050
11. rolutola 8,500
12. DrSQL 8,080
13. nav_kum_v 7,416
14. markgeer 7,100
15. Sqaimes 6,450
16. sonicefu 6,000
17. sujith80 5,582
18. Dr_Billy 4,900
18. joebednarz 4,900
20. paulop1... 4,750
21. Milleniuma... 4,550
22. sventhan 4,300
23. shajukg 3,000
24. Wolfgang... 2,600
24. mj_norwich 2,600
24. dragos_c... 2,600

1. sdstuber 83,860
2. schwertner 59,210
3. angelIII 46,882
4. johnsone 37,556
5. sujith80 32,320
6. jinesh_ka... 25,850
7. aiklamha 24,600
8. MikeOM_... 22,800
9. markgeer 18,175
10. nav_kum_v 17,366
11. slightwv 14,625
12. dbmullen 12,900
13. dvz 11,789
14. Akenathon 11,050
15. jwahl 10,480
16. joebednarz 9,675
17. rolutola 9,300
18. DrSQL 8,080
19. Sqaimes 6,450
20. ishando 6,400
21. sonicefu 6,150
22. konektor 5,832
23. Dr_Billy 4,900
23. NicksonKoh 4,900
23. YANN0S 4,900

05.19.2008 at 08:56PM PDT, ID: 23416014

	[x] Attachment Details

Oracle Database Upgradation from 8.1.7 to 10g - UTF issue.

Asked by kailash30 in Oracle 8.x, Oracle 9.x, Oracle 10.x

Tags: Oracle, Oracle, 8.1.7, The current Oracle version is 8.1.7. & the plan is to migrate to 10g. It has been observed that there are millions of rows that have illegal characters (European characters) since the 8.1.7 NLS is USA

Hi Support,
The current Oracle version is 8.1.7. & the plan is to migrate to 10g. It has been observed that there are millions of rows that have illegal characters (European characters) since the 8.1.7 NLS is USASCII7 while 10g will have the NLS of UTF 8.
The current oracle 8.1.7 is not capable of handling the special characters. There are few strategies which are thought of as follows
1)Convert existing European characters to UTF 8 in 10g before data migration. But this will be a huge effort.
2)Possibility of importing to 10g as is (ASCII 7), thus allow future data to be in UTF 8. But since the 10g database is already configured for UTF 8 it will by default store it in UTF 8, thus the migrated data, though imported in ASCII 7 will still be stored as UTF 8?
Please let me know your view.
Regards,
Kailash
Start Free Trial

Keywords: Oracle Database Upgradation from 8.…

	Title
1	Oracle Database Upgrade
2	.Net / Oracle api
3	Oracle Vs SQL2000
4	Comparison between Oracle and DB2
5	Migrating from ORACLE 8.1.7.4 …
6	Upgrading from Oracle 9.2 to Oracle…

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Oracle Database Upgradation from 8.1.7 to 10g - UTF issue.

Asked by kailash30 in Oracle 8.x, Oracle 9.x, Oracle 10.x

Tags: Oracle, Oracle, 8.1.7, The current Oracle version is 8.1.7. & the plan is to migrate to 10g. It has been observed that there are millions of rows that have illegal characters (European characters) since the 8.1.7 NLS is USA

About this solution