• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Special chars are getting in bsv file

 
Krish Yeruva
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
  • 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

 
Ulf Dittmer
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • 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
  • 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
  • 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: 42968
73
  • Mark post as helpful
  • send pies
  • 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.
 
Paul Clapham
Sheriff
Posts: 21416
33
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • 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
  • 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: 42968
73
  • Mark post as helpful
  • send pies
  • 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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic