Sponsored Content
Top Forums Shell Programming and Scripting Encoding conversion in PERL script Post 302381763 by pludi on Sunday 20th of December 2009 12:05:42 PM
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.
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. Solaris

View file encoding then change encoding.

Hi all!! I´m using command file -i myfile.xml to validate XML file encoding, but it is just saying regular file . I´m 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
HTML::FormFu::Manual::Unicode(3pm)			User Contributed Perl Documentation			HTML::FormFu::Manual::Unicode(3pm)

NAME
HTML::FormFu::Manual::Unicode - Working with unicode DESCRIPTION
Working with unicode. For a practical example, see the Catalyst application in the "examples/unicode" directory in this distribution. ASSUMPTIONS
In this tutorial, we're assuming that all encodings are UTF-8. It's relatively simple to combine different encodings from different sources, but that's beyond the scope of this tutorial. For simplicity, we're also going to assume that you're using Catalyst for your web-framework, DBIx::Class for your database ORM, TT for your templating system, and YAML format "HTML::FormFu" configuration files, with YAML::XS installed. However, the principles we'll cover should translate to whatever technologies you chose to work with. BASICS
To make it short and sweet: you must decode all data going into your program, and encode all data coming from your program. Skip to "CHANGES REQUIRED" if you want to see what you need to do without any other explanation. INPUT
Input parameters from the browser If you're using "Catalyst", Catalyst::Plugin::Unicode will decode all input parameters sent from the browser to your application - see "Catalyst Configuration". If you're using some other framework or, in any case, you need to decode the input parameters yourself, please take a look at HTML::FormFu::Filter::Encode. Data from the database If you're using DBIx::Class, DBIx::Class::UTF8Columns is likely the best options, as it will decode all input retrieved from the database - see "DBIx::Class Configuration". In other cases (i.e. plain DBI), you still need to decode the string data coming from the database. This varies depending on the database server. For MySQL, for instance, you can use the "mysql_enable_utf8" attribute: see DBD::mysql documentation for details. Your template files Set TT to decode all template files - see "TT Configuration". HTML::FormFu's own template files Set "HTML::FormFu" to decode all template files - see "HTML::FormFu Template Configuration". HTML::FormFu form configuration files If you're using "YAML" config files, your files will automatically be decoded by "load_config_file|HTML::FormFu/load_config_file" and "load_config_filestem|HTML::FormFu/load_config_filestem". If you have Config::General config files, your files will automatically be decoded by "load_config_file|HTML::FormFu/load_config_file" and "load_config_filestem|HTML::FormFu/load_config_filestem", which automatically sets Config::General's "-UTF8" setting. Your perl source code Any perl source files which contain Unicode characters must use the utf8 module. OUTPUT
Data saved to the database With "DBIx::Class", DBIx::Class::UTF8Columns will encode all data sent to the database - see "DBIx::Class Configuration". HTML sent to the browser With "Catalyst", Catalyst::Plugin::Unicode will encode all output sent from your application to the browser - see "Catalyst Configuration". In other circumstances you need to be sure to output your Unicode (decoded) strings in UTF-8. To do this you can encode your output before it's sent to the browser with something like: use utf8; if ( $output && utf8::is_utf8($output) ){ utf8::encode( $output ); # Encodes in-place } Another option is to set the "binmode" for "STDOUT": bindmode STDOUT, ':utf8'; However, be sure to do this only when sending UTF-8 data: if you're serving images, PFD files, etc, "binmode" should remain set to ":raw". CHANGES REQUIRED
Catalyst Configuration Add Catalyst::Plugin::Unicode to the list of Catalyst plugins: use Catalyst qw( ConfigLoader Static::Simple Unicode ); DBIx::Class Configuration Add DBIx::Class::UTF8Columns to the list of components loaded, for each table that has columns storing unicode: __PACKAGE__->load_components( qw( UTF8Columns HTML::FormFu PK::Auto Core ) ); Pass each column name that will store unicode to "utf8_columns()": __PACKAGE__->utf8_columns( qw( lastname firstname ) ); TT Configuration Tell TT to decode all template files, by adding the following to your application config in MyApp.pm package MyApp; use strict; use parent 'Catalyst'; use Catalyst qw( ConfigLoader ); MyApp->config({ 'View::TT' => { ENCODING => 'UTF-8', }, }); 1; HTML::FormFu Template Configuration Make "HTML::FormFu" tell TT to decode all template files, by adding the following to your "myapp.yml" Catalyst configuration file: package MyApp; use strict; use parent 'Catalyst'; use Catalyst qw( ConfigLoader ); MyApp->config({ 'Controller::HTML::FormFu' => { constructor => { tt_args => { ENCODING => 'UTF-8', }, }, }, }); 1; These above 2 examples should be combined, like so: package MyApp; use strict; use parent 'Catalyst'; use Catalyst qw( ConfigLoader ); MyApp->config({ 'Controller::HTML::FormFu' => { constructor => { tt_args => { ENCODING => 'UTF-8', }, }, }, 'View::TT' => { ENCODING => 'UTF-8', }, }); 1; AUTHORS
Carl Franks "cfranks@cpan.org" Michele Beltrame "arthas@cpan.org" (contributions) COPYRIGHT
This document is free, you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.14.2 2011-05-10 HTML::FormFu::Manual::Unicode(3pm)
All times are GMT -4. The time now is 06:04 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy