SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Convert character encoding to WE8MSWIN1252 from AL32UTF8

3566413Mar 20 2018 — edited Mar 20 2018

Hi,

I am using utl file package to generate file from oracle .NLS_CHARACTERSET in DB is AL32UTF8 and the source system which the data importing doesn't support UTF8.

I am using oracle version Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit.

I tried to use convert (string , 'WE8MSWIN1252', 'AL32UTF8') but it is not working .It is working fine if i include some particular column.

Is there any prerequest which i have to do before using above function.

ex: Do i need to convert the string to to_nchar or to_single_byte etc.

Thanks,

Shine.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 17 2018

Added on Mar 20 2018

4 comments

5,292 views