UTF-8 Problem

Hi,

    I  have a file stored in blob field, this file contains characters in utf-8 fotmat


    I'm triying to catch the end of line with

          dbms_lob.read(var_blob,ofsetlen,var_seek_point,lv_buffer);
          lv_line:=CONVERT(utl_raw.cast_to_varchar2(lv_buffer),'UTF8');

          var1:=instr(file_str,initial_pos,chr(13)||chr(10));


     this works for all lines, except when line contains "un normal" characters like ñ or anothers like this...

       when the lines contains unnormal character the value for    "var1"    is 1 , why ?

      Maybe  I'm not processing correclty the character stored in utf-8

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 13 10
xxxxxxxxxxxxxxxxxxÑxxxxxxxxxxxxxxxxxxx 13 10
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 13 10
xxxxxxxxxxxxxxxxxxxxxxxxÇxxxxxxxxxxxxx 13 10
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx 13 10


line 1, 3 , 5 works fine, but line 2 and 4 don't


Regards
MARCELO





mosorioAsked:
Who is Participating?
 
Helena MarkováConnect With a Mentor programmer-analystCommented:
Maybe you will find some useful informations on this site:
http://asktom.oracle.com/pls/ask/f?p=4950:1:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.