Database conversion from US7ASCII to UTF8 
Author Message
 Database conversion from US7ASCII to UTF8

We have a front-end application thats running on java servlets/perl/jdbc
connected to an oracle 8.1.6 database and recently we did a conversion
of database from US7ASCII to UTF8 to support multi-lingual features. As
US7ASCII is a strict superset to UTF8, i was able to change the database
characterset as well national character set without any problems. Also,
i was told to do an export and import with NLS_LANG properly set to
avoid any non-ascii chars dangling in the database without being
converted to UTF8. So everything went well without any issues, but now
all the non-ascii characters i.e. > 128 that were in US7ASCII database,
now got converted to ? in UTF8 database. Is there a way to avoid these ?
marks as am getting sun.io.MalformedInput Exception error on our java
front-ends. But if i do an update on the tables like below, i get away
with these errors.

update x set col1=convert(col1, 'UTF8', 'US7ASCII')
where col1!=convert(col1, 'US7ASCII');

Note : all our frontend applications input forms are also utf8 complaint.

any solutions or workarounds.

-Stan



Mon, 16 Aug 2004 18:08:10 GMT
 Database conversion from US7ASCII to UTF8

Quote:

> We have a front-end application thats running on java servlets/perl/jdbc
> connected to an oracle 8.1.6 database and recently we did a conversion
> of database from US7ASCII to UTF8 to support multi-lingual features. As
> US7ASCII is a strict superset to UTF8, i was able to change the database
> characterset as well national character set without any problems. Also,
> i was told to do an export and import with NLS_LANG properly set to
> avoid any non-ascii chars dangling in the database without being
> converted to UTF8. So everything went well without any issues, but now
> all the non-ascii characters i.e. > 128 that were in US7ASCII database,
> now got converted to ? in UTF8 database. Is there a way to avoid these ?
> marks as am getting sun.io.MalformedInput Exception error on our java
> front-ends. But if i do an update on the tables like below, i get away
> with these errors.

> update x set col1=convert(col1, 'UTF8', 'US7ASCII')
> where col1!=convert(col1, 'US7ASCII');

> Note : all our frontend applications input forms are also utf8 complaint.

> any solutions or workarounds.

> -Stan

Please clarify, did you export with nls_lang = us7ascii and import with
nls_lang = utf8, or was both exp and imp done with nls_lang = utf8?

/Svend



Tue, 17 Aug 2004 03:37:46 GMT
 Database conversion from US7ASCII to UTF8
Infact i did the export/import having nls_lang set to american_america.utf8
Quote:


>> We have a front-end application thats running on java
>> servlets/perl/jdbc connected to an oracle 8.1.6 database and recently
>> we did a conversion of database from US7ASCII to UTF8 to support
>> multi-lingual features. As US7ASCII is a strict superset to UTF8, i
>> was able to change the database characterset as well national
>> character set without any problems. Also, i was told to do an export
>> and import with NLS_LANG properly set to avoid any non-ascii chars
>> dangling in the database without being converted to UTF8. So
>> everything went well without any issues, but now all the non-ascii
>> characters i.e. > 128 that were in US7ASCII database, now got
>> converted to ? in UTF8 database. Is there a way to avoid these ? marks
>> as am getting sun.io.MalformedInput Exception error on our java
>> front-ends. But if i do an update on the tables like below, i get away
>> with these errors.

>> update x set col1=convert(col1, 'UTF8', 'US7ASCII')
>> where col1!=convert(col1, 'US7ASCII');

>> Note : all our frontend applications input forms are also utf8 complaint.

>> any solutions or workarounds.

>> -Stan

> Please clarify, did you export with nls_lang = us7ascii and import with
> nls_lang = utf8, or was both exp and imp done with nls_lang = utf8?

> /Svend



Tue, 17 Aug 2004 15:18:16 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Characters beyond ASCII in database ( US7ASCII and UTF8 character set )

2. Character set conversion to UTF8 from WE8ISO8859P1 to UTF8

3. US7ASCII vs UTF8 performance

4. Change Chracter Set - UTF8 to US7ASCII

5. How do I migrate from US7ASCII on 8.0.5 to UTF8 on 8i

6. character set conversion: AL24UTFFSS to UTF8

7. utf8 - ascii conversion

8. utf8 <-> sjis conversion problem

9. Solution: UCS2 / UTF8 / Oracle / Fail to convert between UTF8 and UCS2

10. reading from a chinese database stored as utf8 in sybase SQl anywhere

11. Updating CLOB column in a UTF8 database

12. Problem when inserting data into UTF8 database using VB and ADO


 
Powered by phpBB® Forum Software