Visit Our UNIX and Linux User Community


Encoding conversion in PERL script


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Encoding conversion in PERL script
# 1  
Old 12-20-2009
Java Encoding conversion in PERL script

I have oracle 9i database installed with UTF-8 Encoding.
I want a perl script that converts unicode to utf8 before commiting in database and utf8 to unicode when retreiving from database
For example :
the word ntrnatnlztion has to be stored in database as Internationalization and when retreived from database, it should not lose the original meaning.

Can u suggest any solution in PERL script.
# 2  
Old 12-20-2009
utf8 pragma.

google search ( utf8 - perldoc.perl.org ).. Hopefully it can help you.
# 3  
Old 12-20-2009
i suggest you post this at PerlMonks.

Last edited by pludi; 12-20-2009 at 12:41 PM.. Reason: removed link
# 4  
Old 12-20-2009
Thanks for the solution.
But it was not clear.
Is there any other method?
# 5  
Old 12-20-2009
Well, our answers can only be as clear as your question. Do you want to convert between character sets? Or do you want to save it in a different character set and retrieve it in the original?

Besides, you do know that UTF8 is a variant of Unicode?
# 6  
Old 12-20-2009
Let me be more clear.
There is a word which i have to save it in database.(The word i'm saving is ntrnatnlztion). If i save as ntrnatnlztion, it is saving some junk characters.
So i want a perl script that saves the word ntrnatnlztion as Internationalization
and when retreiving from database, i want it as ntrnatnlztion.
Hopefully i am clear by this.
# 7  
Old 12-20-2009
How are you accessing the database? Via DBI? Then it shouldn't be a problem, since Perl itself uses Unicode already. Via SQL*Plus? Then you should take a look at the various NLS settings for Oracle, because sometimes it tries to convert strings for you, even if you don't want to.

Also, I think the various to_char functions can do character set conversion.

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Solaris

View file encoding then change encoding.

Hi all!! Im using command file -i myfile.xml to validate XML file encoding, but it is just saying regular file . Im expecting / looking an output as UTF8 or ANSI / ASCII Is there command to display the files encoding? Thank you! (2 Replies)
Discussion started by: mrreds
2 Replies

2. Shell Programming and Scripting

Conversion of Perl Script to Shell Script..

Hi Guys I am having a perl script that fetches exclude list from a unix client and I trying it to convert it to shell script but I am having issues please help me... #!/usr/bin/perl use strict; use warnings; use Getopt::Std; # To turn on debuging (i.e. more information) specify... (29 Replies)
Discussion started by: Pawan Ramnani
29 Replies

3. Shell Programming and Scripting

Color encoding on the disk space script

Hi All, Hope all are doing good!! Am glad that i have utilized some ideas and written a code to make the disk space result comes better and it was successfully running in the production. The next update from my manager was to make this code to come in a table format with color added. 1)... (28 Replies)
Discussion started by: Kalaihari
28 Replies

4. Shell Programming and Scripting

Help required for Oracle database shutdown script conversion from shell to perl

Please tell me how to convert below program from shell script to perl. Same commands need to use in shutdown, just need program help for startup. export ORACLE_BASE=/home/oracle1 lsnrctl start lndb1 sqlplus '/ as sysdba' startup; (2 Replies)
Discussion started by: learnbash
2 Replies

5. Shell Programming and Scripting

conversion of loop in perl

Hello Sir, How can i convert below two loop lines in perl for BLOCK in /sys/block/myblock* for BLOCK in /dev/myblock* How i can write them in perl like foreach( </sys/block/myblock*/queue/nr_requests> ) (5 Replies)
Discussion started by: learnbash
5 Replies

6. Shell Programming and Scripting

Timestamp conversion in PERL

Hi, I have a file as below I need to overwrite the 2 nd column alone to numeric format like "06122011030414012345" as per the timestamp value output file should be the microseconds can be neglected if required. Any help will be appreciated. Thanks in advance (1 Reply)
Discussion started by: irudayaraj
1 Replies

7. Shell Programming and Scripting

shell or perl script needed for ldif file to text file conversion

This is the ldf file dn: sdcsmsisdn=1000000049,sdcsDatabase=subscriberCache,dc=example,dc=com objectClass: sdcsSubscriber objectClass: top postalCode: 29600 sdcsServiceLevel: 10 sdcsCustomerType: 14 givenName: Adelia sdcsBlackListAll: FALSE sdcsOwnerType: T-Mobile sn: Actionteam... (1 Reply)
Discussion started by: LinuxFriend
1 Replies

8. Shell Programming and Scripting

perl instead of grep 'conversion' help?

Hello: I butchered a shell script together, but my script kung-fu is 5 years old and all I've used for 5 years are for i loops. I hope that some perl guru can do in 5 minutes what takes me 5 weeks, so I am asking for help. I have a simple script using "grep -A 2 'string' /path/to/file" but... (4 Replies)
Discussion started by: Habitual
4 Replies

9. Shell Programming and Scripting

[Perl] Timestamp conversion

Hi, I have searched, read and tried, but no luck. I have this code: #!/bin/perl -w #-d use strict; use POSIX qw(strftime); my $getprpw_list="/usr/lbin/getprpw -l"; my $host = "nbsol151"; my $user = "genadmin"; my %uid; my %spwchg; my %upwchg; my %slogint; (2 Replies)
Discussion started by: ejdv
2 Replies

10. Shell Programming and Scripting

Conversion of bash parsing script to perl?

I need help with a perl parsing script. I have some error logs on a windows machine that I need to parse from a text file, but I know nothing about perl. I usually run this bash script on my linux box and it does just what I need. How would I do the same thing with perl and port it to my windows... (2 Replies)
Discussion started by: cstovall
2 Replies

Featured Tech Videos