Special characters

From: Spiraquis Alexis (spiraqua_at_telefonica.com.ar)
Date: 01/28/05

  • Next message: Femi: "Executing sproc containing multiple inserts and commits with Perl DBI" 
    To: dbi-users@perl.org
Date: Fri, 28 Jan 2005 16:00:30 -0300

    Hello

    I have problems getting special characters (like quotes, ñ, vocals with
    accents, etc) from the database through DBI.
    The Database is Oracle 7.3.4
    If I execute the query with Sql Plus it returns the characters ok but after
    getting the data through DBI the characters change.
    Does the language of Perl or DBI installed influence?

    Thank you very much
    Alexis

  • Next message: Femi: "Executing sproc containing multiple inserts and commits with Perl DBI"

    Relevant Pages

    • Re: Loading a data file containing character fields with different encodings
      ... The data is coming from one database that contains UTF-8 characters and it appears that he's attempting to load ... UTF-8 characters along with Latin-1 characters. ... it would be just as easy to write the loader script that converts the encoding to a "unicode" intermediate format and then load with the correct database encoding. ...
      (comp.databases.informix)
    • Re: Loading a data file containing character fields with different encodings
      ... The data is coming from one database that contains UTF-8 characters and it appears that he's attempting to load ... UTF-8 characters along with Latin-1 characters. ... it would be just as easy to write the loader script that converts the encoding to a "unicode" intermediate format and then load with the correct database encoding. ...
      (comp.databases.informix)
    • Re: Size matters to some
      ... BobJ wrote: ... specified to the DBMS tools with a maxlen specification, ... database does, without the maxlen specification to the DBMS. ... Field A is supposed to be 2 characters of a country abbreviation, ...
      (comp.databases.pick)
    • RE: fetchrow_array performance
      ... I agree - set RasieError. ... it is impossible to tell what is going on in the database without a 10046 trace. ... You aren't error checking your dbi statements - do you have RaiseError ... sender of the delivery error by replying to this message, or notify us by ...
      (perl.dbi.users)
    • Re: Evaluated "require $database" not found.
      ... DBI Error 1046: No database selected ... What I have found is that if the spaceare removed as per the correct syntax, then the DBI_errorhandler will trap and report a connection failure if a non-existent database is specified, as per this example: ... This requires that you first have an installation of mysql setup on a host ...
      (perl.dbi.users)