CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: Intermediate:
French characters from Excel

 



zatlas1
Novice

Jun 14, 2013, 9:27 AM

Post #1 of 3 (529 views)
French characters from Excel Can't Post

Hi all

I am getting an Excel spreadsheet with French names (e.g. LÉVESQUE)

I need to insert that to Oracle database (I know to use

use utf8;

binmode FILEHANDLE,':utf8';

but, here I need to insert to the database. How do I do that? The characters in the database appear to be corrupted



Thanks

ZA


Laurent_R
Veteran / Moderator

Jun 15, 2013, 12:49 PM

Post #2 of 3 (509 views)
Re: [zatlas1] French characters from Excel [In reply to] Can't Post

Do you need the accented letter to be kept or removed?

If it need to be kept, well the problem might come from your database rather than Perl. Which database? Which character set is used in the DB? Can you insert accented letters in the database using another program than Perl?


zatlas1
Novice

Jun 15, 2013, 7:29 PM

Post #3 of 3 (506 views)
Re: [Laurent_R] French characters from Excel [In reply to] Can't Post

 
It need it to be kept
Oracle
AL32UTF8

We have no problem from other programs (java, etc.)

Thank you

 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives