+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 14

How to convert data with different charsets into other databases?

  1. How to convert data with different charsets into other databases?

    hi
    we want to use database link to connect a Database for operating the
    select,update or ... commands,our destination database is WE8ISO8859P1
    and current database is AR8MSWIN1256 cahrset, but when we operate a
    command to view data,all NonEnglish characters appear odd wich we can
    not recognize the appeared text, also if we use convert function no
    change would make, please help us to view right charachters with our
    database link.
    thanks

  2. Re: How to convert data with different charsets into otherdatabases?

    On Tue, 01 Mar 2011 23:49:45 -0800, Shahabeddin Hosseinkhah wrote:

    > hi
    > we want to use database link to connect a Database for operating the
    > select,update or ... commands,our destination database is WE8ISO8859P1
    > and current database is AR8MSWIN1256 cahrset, but when we operate a
    > command to view data,all NonEnglish characters appear odd wich we can
    > not recognize the appeared text, also if we use convert function no
    > change would make, please help us to view right charachters with our
    > database link.
    > thanks


    I am not sure what seems to be the problem Oracle*Net does the conversion
    automatically. This may be a problem with your client.



    --
    http://mgogala.byethost5.com

  3. Re: How to convert data with different charsets into other databases?

    On Mar 2, 7:49*am, Shahabeddin Hosseinkhah
    wrote:
    > hi
    > we want to use database link to connect a Database for operating the
    > select,update or ... commands,our destination database is WE8ISO8859P1
    > and current database is AR8MSWIN1256 cahrset, but when we operate a
    > command to view data,all NonEnglish characters appear odd wich we can
    > not recognize the appeared text, also if we use convert function no
    > change would make, please help us to view right charachters with our
    > database link.
    > thanks


    As Mladen says, check the NLS settings on your client.

    HTH

    -g

  4. Re: How to convert data with different charsets into other databases?

    On Mar 1, 11:49*pm, Shahabeddin Hosseinkhah
    wrote:
    > hi
    > we want to use database link to connect a Database for operating the
    > select,update or ... commands,our destination database is WE8ISO8859P1
    > and current database is AR8MSWIN1256 cahrset, but when we operate a
    > command to view data,all NonEnglish characters appear odd wich we can
    > not recognize the appeared text, also if we use convert function no
    > change would make, please help us to view right charachters with our
    > database link.
    > thanks


    The problem could simply be in how you are viewing it, perhaps the
    code set on your PC. MOS has a number of documents explaining NLS
    issues, the docs have the globalization guide, and Frank has an
    informative blog series: http://vanbortel.blogspot.com/2009/0...rs-part-i.html

    You can use the select dump(yourdata) from yourtable in sqlplus to be
    sure the values are the same from each side of the link.

    jg
    --
    @home.com is bogus.
    http://www.signonsandiego.com/news/2011/mar/01/fox/


  5. Re: How to convert data with different charsets into other databases?

    On 2011-03-02 08:49, Shahabeddin Hosseinkhah wrote:
    > hi
    > we want to use database link to connect a Database for operating the
    > select,update or ... commands,our destination database is WE8ISO8859P1
    > and current database is AR8MSWIN1256 cahrset, but when we operate a
    > command to view data,all NonEnglish characters appear odd wich we can
    > not recognize the appeared text, also if we use convert function no
    > change would make, please help us to view right charachters with our
    > database link.
    > thanks


    As mswin1256 is a "richer" (more characters & signs defined) than
    we8iso8859p1, You will loose stuff when saving in the "narrow" charset.
    To avoid this create your databases with a larger charset as utf8 or
    al32utf16, or whatever is fitting Your needs.

    /Svend

  6. Re: How to convert data with different charsets into otherdatabases?

    On Thu, 24 Mar 2011 21:07:34 +0100, Svend Jensen wrote:

    > As mswin1256 is a "richer" (more characters & signs defined) than
    > we8iso8859p1, You will loose stuff when saving in the "narrow" charset.
    > To avoid this create your databases with a larger charset as utf8 or
    > al32utf16, or whatever is fitting Your needs.
    >
    > /Svend



    I don't understand why would anyone need anything but US7ASCII? The
    database world would be so much simpler, if only everyone spoke English.
    When I say "English", I don't mean the exotic versions with the wrong
    spelling, like "doughnut", "colour", "humour" etc.


    04/01 is close enough to send a post like this.



    --
    http://mgogala.byethost5.com

  7. Re: How to convert data with different charsets into otherdatabases?

    Preston wrote,on my timestamp of 25/03/2011 8:09 PM:

    >>
    >>
    >> I don't understand why would anyone need anything but US7ASCII? The
    >> database world would be so much simpler, if only everyone spoke
    >> English. When I say "English", I don't mean the exotic versions with
    >> the wrong spelling, like "doughnut", "colour", "humour" etc.
    >>

    >>
    >> 04/01 is close enough to send a post like this.

    >
    > What's the 4th January got to do with your abhorrent abuse of the
    > English language..?
    >


    Everything! It's the Murrican (speaking of abhorrent abuse of the Queen's
    language!) way of saying April Fool's.

  8. Re: How to convert data with different charsets intootherdatabases?

    On Fri, 25 Mar 2011 22:16:02 +1100, Noons wrote:


    > Everything! It's the Murrican (speaking of abhorrent abuse of the
    > Queen's language!) way of saying April Fool's.


    Hmmm, it looks like NLS will not fade away any time soon.



    --
    http://mgogala.byethost5.com

  9. Re: How to convert data with different charsets into otherdatabases?

    Noons:

    # Everything! *It's the Murrican (speaking of abhorrent abuse of the
    Queen's language!) way of saying April Fool's.

    Dude the english are a group of people ruled ( historically speaking
    anyway ) by a bizarre set of individuals who brutally treated as much
    of the world as they could hold onto to a series of pretty much
    unspeakable levels of despotism/slaughter/colonialism.

    Not convinced exactly that the current US politicians ( as much as I
    worked to elect the current president ) are much better. Harsh
    realities and strategic interests in natural resources make the next
    50 years look pretty ugly.

    But "english" is dead ... seriously it is American ... has been for a
    really long time.

    Just get over it ...





  10. Re: How to convert data with different charsets into otherdatabases?

    On 25 mrt, 10:09, "Preston" wrote:
    > Mladen Gogala wrote:
    > > On Thu, 24 Mar 2011 21:07:34 +0100, Svend Jensen wrote:

    >
    > > > As mswin1256 is a "richer" (more characters & signs defined) than
    > > > we8iso8859p1, You will loose stuff when saving in the "narrow"
    > > > charset. *To avoid this create your databases with a larger charset
    > > > as utf8 or al32utf16, or whatever is fitting Your needs.

    >
    > > > /Svend

    >
    > >
    > > I don't understand why would anyone need anything but US7ASCII? The
    > > database world would be so much simpler, if only everyone spoke
    > > English. *When I say "English", I don't mean the exotic versions with
    > > the wrong spelling, like "doughnut", "colour", "humour" etc.
    > >

    >
    > > 04/01 is close enough to send a post like this.

    >
    > What's the 4th January got to do with your abhorrent abuse of the
    > English language..?
    >


    Except the period just before April Fool's, Mladens abuse of the
    English language is quite innocuous...

    --
    Jeroen

+ Reply to Thread
Page 1 of 2 1 2 LastLast