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!

Issue with LPAD/RPAD when using with Japanese data

874135Jul 7 2011 — edited Jul 8 2011

Hi,

I am trying to apply LPAD/RPAD on Japanese data, but its giving different results than expected.

LPAD/RPAD is returning less data than length passed.

Database: Oracle 10g

Could some one help me on this.

SQL Query: select length('アップリカ'),lpad('アップリカ',5,' '), length(lpad('アップリカ',5,' ')) from dual;

Output:

LENGTH('アップリカ') --> *5*
LPAD('アップリカ',5,'') --> アッ
LENGTH(LPAD('アップリカ',5,'')) --> *3*

Thanks in advance !!

Edited by: 871132 on Jul 7, 2011 8:18 PM

Edited by: 871132 on Jul 7, 2011 8:20 PM

Edited by: 871132 on Jul 7, 2011 8:21 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 5 2011

Added on Jul 7 2011

2 comments

3,420 views