| Multi Byte conversion [message #556370] |
Sat, 02 June 2012 21:07  |
 |
cbaskar99
Messages: 2
Registered: June 2012
Location: Chennai
|
Junior Member |
|
|
Hi,
My application spools the data from database into file and file is fixed length. My application working fine when database has single byte characters. But I am getting fields postion misposition and length mismatch in spooled line when data base has Multi byte characters(ê).
Can you pls. help me to fix the issue. I want to convert the multi byte characters into single byte while spooling the data( ê ==> e)
The below query has converted the multi byte to single byte character. But actual value is modified into lower case. Pls. help me to resolve this issue or suggest me the appropriate function.
####################################################
select utl_raw.cast_to_varchar2((nlssort(c.Name,'nls_sort=binary_ai'))) sbyte, '|'
c.Name
from EMP c
viva! experiencias | Viva! Experiências
####################################################
Regards,
C. Baskar
|
|
|
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
