• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Special chars are getting in bsv file

 
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Team,
In oracle, one of my stored proc is using tables and views and generating the xxx.bsv file. In this bsv file, some special chars(Â) are getting displayed. I have checked the tables and views, is there any special chars in them. But tables and views doesn't have any funky chars in it. But the xxx.bsv file is having the funky chars(Â). So can you please suggest me what modification I can do to remove those funky chars(Â) in xxx.bsv file?

Eg:
FOUSA00BWW|FSUSA001YS||Fidelity Advisor® Strategic Income Fund Class T|Fidelity Advisor® Strategic Income

Thanks In Advance
Krishna

 
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I would imagine that whichever application you use to display the CSV doesn't employ the right encoding. Which encoding is used for creating the file?
 
Krish Yeruva
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Ulf Dittmer,
Thanks for your reply. The destination file is getting created in Winscp(NAS location). So I am trying to open the same file by giving right click on the file and selecting the Edit option. Don't mind how can I check the encoding of such a file?Can't I make any changes in the stored procedure to filter those funky chars in xxx.bsv file?

Note: The file i am trying to open is xxx.bsv, not xxx.csv.




WinscpFileHeader.PNG
[Thumbnail for WinscpFileHeader.PNG]
WinscpFileHeader
 
Krish Yeruva
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
We can see encoding from preferences tab-->Editors-->Encoding . But in my Winscp i am not able to see the encoding option..
Preferences.PNG
[Thumbnail for Preferences.PNG]
Preferences
 
Ulf Dittmer
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
The encoding has nothing to do with WinSCP, it's a feature of the file. Open it in an application that makes it easy to try out different encodings, like a web browser.
 
Marshal
Posts: 28193
95
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I've frequently seen text which was encoded in UTF-8 displayed in other encodings, and those strange characters are typically what you see. In your case it looks like there's a ™ character being mangled. So I would suggest telling your editor to use UTF-8 when opening it.
 
Krish Yeruva
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Ulf Dittmer and Paul,
Thanks a lot for you response.
I found one solution to convert the text with funky characters.
In stored procedure iam using convert('Character set','UTF8'), this solved my requirement.
Oracle has nearly the following character sets (as per I know, ofcourse I googled )
US7ASCII, WE8ISO8859P1, EE8MSWIN1250, WE8MSWIN1252, WE8EBCDIC1047, JA16SJISTILDE, ZHT16MSWIN950, AL32UTF8, UTF8
Now I would like to convert into UTF8 whatever the character set it is.
So any one can help me out. How I can achieve this requirement in oracle.

Thanks in advance.



 
Ulf Dittmer
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I'm not sure what you're asking. If the file is created as UTF-8 (which is how I understand your post), then that solves the problem, no?
 
Just the other day, I was thinking ... about this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic