Problem in inserting Spanish characters(accent) into Oracle
Hi All,
I have a problem in inserting Spanish characters(accent) into Oracle. I run the perl script after setting "export NLS_LANG=American_America.UTF8". but still the accents è not been inserted properly. Could anyone help me to fix this issue?
Thanks for your help.
Regards,
Raja
Re: Problem in inserting Spanish characters(accent) into Oracle
created: 2006-02-01 00:23:12
Maybe if you show us a relevant snippet of the code you've written for this? Also, what exactly is showing up in the database instead of the accented characters you want?
(Hmm... è in Spanish??? Don't you mean é?)
Re^2: Problem in inserting Spanish characters(accent) into Oracle
created: 2006-02-01 00:29:27
Here is the code snapshot,
my $insert_sql = qq!
insert into C_LANG_ITEMS
(lang_code,key,final_translation)
values('ES',:1,:2)
!;
Here is the data,
- Seleccione al menos un término de carga
Re^2: Problem in inserting Spanish characters(accent) into Oracle
created: 2006-02-01 00:30:01
Here is the code snapshot, my $insert_sql = qq! insert into C_LANG_ITEMS (lang_code,key,final_translation) values('ES',:1,:2) !; Here is the data, - Seleccione al menos un término de carga
Re^3: Problem in inserting Spanish characters(accent) into Oracle
created: 2006-02-01 00:48:01
You haven't told us yet how the oracle content is different from what you expected to get. What are you using to look at the table contents after the insert is done, and what do you see when you look at that?
It could be that you really are getting the utf8 character data into oracle correctly, but maybe you aren't seeing it as utf8 data when you pull it back out. The DBD::Oracle driver might not be setting the utf8 flag on scalar string values that come back from the database.
If that's the case, you may need to do something like:
use Encode; # ... do whatever it takes to query for inserted text, # and assign the "Spanish" string from the DB to $fldvalue ... # the string value from the DB is not flagged as utf8 in Perl, # so set the utf8 flag: my $fldvalue = decode( 'utf8', $fldvalue );
Re: Problem in inserting Spanish characters(accent) into Oracle
created: 2006-02-01 09:19:36
You don't have to care setting NLS_LANG with export every time you want to run the script. You may forget it sometime.
You can set that at the top of your script like this:
Insert a string converting it into UFT8 from the charset you are using, and then, upon retrieving the string, you convert it from UTF8 into the charset you are working with.
In the example bellow I use the charset suitable for portuguese. It is latin 1, so it should suit your needs
You can set that at the top of your script like this:
$ENV{NLS_LANG} = "AMERICAN_AMERICA.UTF8";
As to the characters being correctly inserted, try and run a test using module Unicode::MapUTF8Insert a string converting it into UFT8 from the charset you are using, and then, upon retrieving the string, you convert it from UTF8 into the charset you are working with.
In the example bellow I use the charset suitable for portuguese. It is latin 1, so it should suit your needs
use Unicode::MapUTF8 qw(to_utf8 from_utf8);
...
#convert into utf8
$str = to_utf8({ -string => 'Your string here', -charset => 'ISO-8859-1' });
# TODO: insert into DB
.....
# TODO: select stuff from database, and then
$str = from_utf8({-string => $str_retrieved, -charset => 'ISO-8859-1'});
# TODO: now check the value of $str