Strange unicode problem with oracle 10g

From: Sascha Schroeder (sascha.schroeder_at_e-pro.de)
Date: 03/17/05

  • Next message: Barak zabari: "Re: How to re-populate DBgrid after doing a search" 
    Date: Thu, 17 Mar 2005 14:41:55 +0100

    Hello,
    we have a strange problem with unicode characters and oracle 10g. If i
    insert a unicode character (0x88AF)
    into a oracle varchar field i get the following error:

    ORA-01460: unimplemented or unreasonable conversion request.

    Ok, let's go on to the very strange things. Now i insert the same unicode
    character and an additional
    single byte character in one literal, for example 'a' (0x61). Now everything
    works fine. The data is stored
    in my table.

    I've figured out that i get an error if my literal contains more multibyte
    (mb) characters than
    single byte (sb) characters. if number of sb chars >= number of mb chars it
    works.

    That's the behavior if i use oracle 10g server and oracle 10 ole db
    provider. But if i use
    oracle 10g server with oracle 8 ole db provider on my client everything is
    fine.

    I've tested the complete scenario with delphi ado components and imported
    ado type library.
    The error occurs only with delphi components, with ado type library i have
    no problems.

    We have also tested with perl and ado type library and it works too. I think
    the error is somewhere
    in the delphi wrapper for ado.

    At the moment we are installing Oracle 8 client at our customers as a
    workaround, but that's not
    a final solution for the problem.

    Any ideas what kind of problem i have?

    Thanks a lot,

    Sascha
    -----------------------------------------------
    Environment:
    Client:
    - Windows 2000
    - Delphi 7
    - Oracle Client (8 or 10)

    Server:
    - Windows 2000
    - Oracle 10g
    - Database in UTF-8
    - Target field is varchar. Length 255

  • Next message: Barak zabari: "Re: How to re-populate DBgrid after doing a search"

    Relevant Pages

    • Re: Storing Queries in Tables
      ... Before I start I am not a Oracle DBA and my knowledge of Oracle is ... Reports are stored as SQL in tables in our main application schema. ... characters like tabs and spaces. ...
      (comp.databases.oracle.misc)
    • Re: Invalid Characters (s) Returned by OracleDataReader
      ... four nearly identical posts in twenty minutes. ... your Oracle driver or the way the application is using .Net. ... -- "RobertoP" wrote in message ... but the data returned by the OracleDataReader object contains random> invalid characters. ...
      (microsoft.public.dotnet.languages.csharp)
    • RE: difficulties with utf-8 characters using DBD::Oracle, where works using DBD::Pg (PostgreSQL) -
      ... DBD::Oracle 1.16, which explained the weird behavior of Oracle with plain ... > and read the documentation about unicode carefully. ... >> special characters. ... >> EOF ...
      (perl.dbi.users)
    • Re: Unicode Character Allocation
      ... I have a quick question regarding how Oracle allocates storage space ... Does Oracle, in UTF-8 mode, actually allocate 4 bytes per every byte ... Characters from the European scripts are represented in either 1 or 2 bytes. ...
      (comp.databases.oracle.server)
    • Re: Delphi bugs and "moving" to Visual Studio debate
      ... mention to them that Delphi is named Delphi because it was to ... development environment for Oracle, ... item 3 (database) is the primary factor for decisions. ... > clients don't even know about any bugs etc in IDE's before they decide ...
      (borland.public.delphi.non-technical)