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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,145 views